22-25 April 2026

From GUI to Scripting: PowerShell for the DBA

Proposed session for SQLBits 2026

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

3 things you'll get out of this session

Learn about how Powershell can help you optimize / automate parts of your repetitive work.