Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules

This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task was no different! Today's tip and trick using dbatools is about generating an Excel workbook that contains lists of SQL Server roles and its members. The … Continue reading Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules

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 write about how we can … Continue reading Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

Backup your SQL instances configurations to GIT with dbatools – Part 1

Today I want to share how I'm keeping a copy of instances' configurations using dbatools. Chrissy LeMaire (B | T) wrote about it before on the Simplifying disaster recovery with dbatools blog post. In this post, I will add one step and save the output on a GIT repository. Pre-requirements You need a GIT repository … Continue reading Backup your SQL instances configurations to GIT with dbatools – Part 1

Replicate permissions to new Login/User with dbatools

Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a way to export the permissions of a login/user at instance/database level and apply them to a new login/user. The typical request Client: "We have a new … Continue reading Replicate permissions to new Login/User with dbatools