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 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...