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]
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]
Backup your SQL instances configurations to GIT with dbatools - Part 2 - Add parallelism
We have seen how we can export and save the results to a folder and commit them to a GIT repository on my last blog post Backup your SQL instances configurations to GIT with dbatools – Part 1. At the end of that post, I have mentioned that I would... [Read More]