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...
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 the setup of a corresponding environment, now we want to fill it with life.For general information on availability groups, I simply refer here to Microsoft's documentat...
In this series of articles I would like to show how an Always On availability group can be set up quickly and conveniently with PowerShell. In this first part, I will first show you how to set up a corresponding environment so that you can follow the commands. If you already have an environment, you will get hints on the necessary requirements here...