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

Wann immer ich eine Schulung zur Administration des Microsoft SQL Servers halte, erzähle ich von den Vorzügen des PowerShell-Moduls dbatools. Ich kann damit viele administrative Aufgaben erledigen, ohne mich per RDP auf dem Server einzuwählen und ohne das SQL Server Management Studio zu starten. Gerade die Administration einer Vielzahl von Instanze...

Regelmäßig werden im Kanal "#dbatools" des Workspace "SQL Server Community" auf der Plattform Slack Fragen nach der richtigen Installation des PowerShell-Moduls dbatools gestellt. Auf diese Frage gibt es verschiedene Antworten, viele davon sind in der Dokumentation beschrieben. Ich möchte hier beschreiben, wie ich die automatisierte Installation au...

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