The DBA’s Blind Spot: Why AI Coding Agents Are Coming for Your Workflow
AI coding agents like GitHub Copilot CLI aren’t just autocomplete they read your files, run commands, and iterate. Here’s why DBAs can’t afford to ignore them.
ALTER DBA ADD AGENT: Practical AI for Database Professionals
A practical guide to using AI coding agents for SQL Server database administration. 18 posts covering T-SQL, monitoring, security, migrations, and more.
Inspecting SQL Server TLS Certificates Without Credentials
If you’ve ever needed to check the TLS certificate on a SQL Server instance — whether it’s expired, misconfigured, missing SANs, or just plain self-signed — you’ve probably had to connect with SSMS, run some…
Teaching GitHub Copilot Your T-SQL Coding Standards
If you’re a DBA or database developer using GitHub Copilot CLI, you’ve probably noticed it generates functional T-SQL — but not necessarily T-SQL that matches your team’s coding standards. After several weeks of working with…
Part 2: When the AI Code Reviewer Finds Bugs the Optimizer Didn’t
In Part 1, I walked through an interactive session with GitHub Copilot CLI where we optimized a production T-SQL function — cutting memory grants by 80% and logical reads by 73%. I thought we were…
Can GitHub Copilot Optimize Your T-SQL? I Put It to the Test
I’ve been curious about how well AI coding assistants handle real-world T-SQL optimization — not textbook examples, but production code with system DMVs, Availability Groups, and windowed functions. So I pointed GitHub Copilot CLI at…