Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server installation, configuration or even uninstall, but they can also be not so technical like when a colleague join the team and someone needs to request permissions to access the company’s tools (such as ticketing/incidents/VPN/etc). What about when a colleague leaves the company?

Continue reading

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 Usefulness of these Reports These reports are especially useful when performing tech-refreshes (migrating from an old version to a newer one) and you want to do some housekeeping.

Continue reading

This month’s (#127) T-SQL Tuesday is brought by B | T ) and he asked about Non SQL Tips and tricks. As a Windows user I know there are lots of shortcuts and small hacks, that I love, which make my life much easier! Here is my small contribution: Windows tips & tricks and shortcuts WIN + X -> to access a lot of management stuff in a quick way WIN + V -> If you looking for a clipboard manager (keep multiple entries) since Windows 10 (build 1809) we can have it natively.

Continue reading

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 lower down the execution times of our script by leveraging on parallelism. Going parallel When we need to manage dozens of servers/instances, even with automated scripts sometimes we would like that our script finishes faster.

Continue reading

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 GIT tools installed on the server where you are running the script so you can commit your changes dbatools A list or a place to get all instances that you want to run the export Preparation Git repository Clone your repository to a location where dbatools can write to.

Continue reading