Who doesn’t like a good red and verbose exception?
[Read More]
dbatools - Rich Datatypes
Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard.
[Read More]
A (big) SQLPackage caveat
Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just have played a handful of times with FTS, mostly in a didactic way, and not so much in the perspective of...
[Read More]
Recover database encrypted modules code with dbatools
This article was initially posted on SQLServerCentral @ 2020-08-18.
It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it’s simple to overcome this when we have the right permissions.
[Read More]
When one of your DBA colleagues leaves the company, what is your checklist?
Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks.
[Read More]