Pair Programming with AI: Writing Better PowerShell, Faster
Proposed session for SQLBits 2026TL; DR
Learn how DBAs and IT Pros can use AI as a PowerShell pair programmer to generate, refine, and harden automation scripts. See how to prompt, validate, and productionize AI-generated code safely and effectively.
Session Details
PowerShell is the automation backbone for DBAs and IT Pros—but writing reliable, reusable scripts still takes time. In this session, you’ll learn how to use AI as a PowerShell pair programmer to build scripts faster while keeping full control.
We’ll walk through real DBA and infrastructure scenarios, using AI to generate PowerShell functions for administration, validation, and reporting/documentation. You’ll see how to prompt AI to produce clean PowerShell, then refine the output by adding parameter validation, error handling, logging, and help to make it production-ready.
This session focuses on practical workflows DBAs and IT Pros can immediately apply—showing how to use AI safely, iteratively, and effectively to scale automation across more servers, databases, and environments.
We’ll walk through real DBA and infrastructure scenarios, using AI to generate PowerShell functions for administration, validation, and reporting/documentation. You’ll see how to prompt AI to produce clean PowerShell, then refine the output by adding parameter validation, error handling, logging, and help to make it production-ready.
This session focuses on practical workflows DBAs and IT Pros can immediately apply—showing how to use AI safely, iteratively, and effectively to scale automation across more servers, databases, and environments.
3 things you'll get out of this session
Use AI as a PowerShell pair programmer to accelerate DBA and IT automation tasks
Write prompts that generate PowerShell aligned with DBA/IT operational best practices
Refine AI-generated scripts by adding validation, error handling, logging, and reusable structure
Speakers
Ben Miller's other proposed sessions for 2026
Beyond “Set and Forget”: Mastering the Ola Hallengren Maintenance Solution - 2026
DBA Horror Stories and Practical Advice for Surviving Your Worst Day - 2026
Designing a Real-World Recovery Strategy for SQL Server: From Theory to Survival - 2026
From Data to Decisions: Building Agentic AI for Smarter SQL Server Maintenance - 2026