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]
Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules
This was initial posted on SQL Server Central articles.
[Read More]
TSQL Tuesday #127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks.
[Read More]