From GUI to Scripting: PowerShell for the DBA
Proposed session for SQLBits 2026TL; DR
Still clicking through SSMS and wizards? Well, it works.. until you have to do the same thing on ten, fifty or a hundred servers. In this session we'll dig in the wonderfull world of scripting and take a look at how PowerShell, and especially the dbatools module, can help you move DBA tasks from manual clicking to repeatable scripts.
Session Details
Still clicking through SSMS and wizards? Well, it works.. until you have to do the same thing on ten, fifty or a hundred servers. In this session we'll dig in the wonderfull world of scripting and take a look at how PowerShell, and especially the dbatools module, can help you move DBA tasks from manual clicking to repeatable scripts.
We start with an introduction to PowerShell. From there we dive into dbatools demo's and we can use it: discovering and inventorying instances, checking configuration, running health checks, and performing bulk changes across multiple servers.
This session is aimed at DBAs who live in the GUI today and are curious (or a bit scared) about scripting. You’ll leave with a basic understanding of how Powershell can help you with optimizing your work.
We start with an introduction to PowerShell. From there we dive into dbatools demo's and we can use it: discovering and inventorying instances, checking configuration, running health checks, and performing bulk changes across multiple servers.
This session is aimed at DBAs who live in the GUI today and are curious (or a bit scared) about scripting. You’ll leave with a basic understanding of how Powershell can help you with optimizing your work.
3 things you'll get out of this session
Learn about how Powershell can help you optimize / automate parts of your repetitive work.
Speakers
Peter Kruis's other proposed sessions for 2026
An introduction to Extended Events - 2026
Query Store Basics: A DBA’s Best Friend - 2026
Waitstats for the accidental DBA - 2026
From Disarray to Hooray: SQL Server Functions That Simplify T-SQL - 2026
Two Developers, One Mission: Make a Test Database That Doesn’t Suck - 2026