Output results of sp_Blitz in markdown format
Andreas Jordan
Englisch
The sp_Blitz procedure from Brent Ozar's First Responder Kit checks the configuration and state of Microsoft SQL Servers and presents problems found in a tabular format. We like to use this procedure during the first contact with new customers to get a quick overview of their SQL Servers.Recently I learned about the possibility to output the result...
Weiterlesen
Dbatools as a replacement for SQL Server Configuration Manager
Andreas Jordan
Englisch
Controlling or adjusting the network configuration of a Microsoft SQL Server is still a reason for many administrators to connect to the server itself via RDP and start the SQL Server Configuration Manager there. But there is now an alternative to this, because I have added two new commands to the PowerShell module dbatools.  Small overview of...
Weiterlesen
dbatools: How do I get started?
Andreas Jordan
Englisch
Whenever I give a training on Microsoft SQL Server administration, I tell about the benefits of the PowerShell module dbatools. I can use it to perform many administrative tasks without having to connect to the server via RDP and without having to start SQL Server Management Studio. Especially the administration of a large number of instances is th...
Weiterlesen
How to install the PowerShell module dbatools?
Andreas Jordan
Englisch
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 ...
Weiterlesen
Using the SQL Server First Responder Kit with the PowerShell module dbatools
Andreas Jordan
Englisch
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 ...
Weiterlesen
From user to developer - using the PowerShell module dbatools to manage Microsoft SQL Servers
Andreas Jordan
Englisch
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...
Weiterlesen