Understanding Unfamiliar Code: Reverse-Engineering Legacy Procedures
Feed undocumented stored procedures to an AI agent and get clear explanations, dependency maps, and refactoring suggestions. Tame your legacy code.
PowerShell Automation: Backups, Maintenance, and AG Management
Let AI write your PowerShell automation scripts backup management, index maintenance, multi-server health checks, and Agent job deployment.
Automating Server Health Checks and Inventory Scripts
Generate server health check and inventory scripts with AI backup status, disk space, version audits, AG health, and configuration drift detection.
Writing T-SQL with an AI Partner
Use AI to write T-SQL faster generating functions, complex JOINs, window functions, and optimization suggestions. Practical prompts for real DBA work.
Getting Started: Your First Hour with GitHub Copilot CLI
Install GitHub Copilot CLI, run your first prompt, and understand how the context window works. A hands-on setup guide for SQL Server DBAs.
What Can an AI Coding Agent Actually Do for a DBA?
A survey of every DBA task area where AI coding agents add real value from T-SQL writing to security audits, incident response, and migration planning.