Questions are regularly asked in the "#dbatools" channel of the "SQL Server Community" workspace on the Slack platform about the correct installation of the dbatools PowerShell module. There are several answers to this question, many of which are described in the documentation. I would like to describe here how I perform the automated installation ...

The SQL Server First Responder Kit by Brent Ozar should be familiar to most database administrators, all others please have a look at Brent Ozar's website or directly at the corresponding GitHub repository.The PowerShell module dbatools may not be known to everyone yet, especially if you haven't had any contact with PowerShell before or fully rely ...

First use in our training courses The story started when I wanted to show my participants in the Administration Course for Microsoft SQL Server in what ways they can perform administrative activities: With the graphical interface of SQL Server Management Studio, with SQL scripts or just with PowerShell, specifically with the dbatools module.This mo...

 In this article I would like to take you behind the scenes of the PowerShell module dbatools, which I love to use for working with Microsoft SQL Server.The starting point will be a simple query on a table consisting of only a single line of code: Invoke-DbaQuery -SqlInstance 'SRV1\SQL2016' -Query 'SELECT * FROM test01.dbo.testd...

In this series of articles I would like to show how an Always On availability group can be set up quickly and comfortably with PowerShell. In the first part we first dealt with setting up an appropriate environment, in the second part we set up the Windows failover cluster, in the third part the SQL Server instances and the sample da...

In this series of articles I would like to show how an Always On availability group can be set up quickly and comfortably with PowerShell. In the first part we first dealt with setting up an appropriate environment, in the second part we set up the Windows failover cluster, now we want to install the SQL Server instances.Besides the Power...