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…
RegEx Replace in SSMS
Refactoring Transact-SQL code can be a time-consuming and frustrating affair for the trusty code-reviewing Database Developer. This post shows several techniques I use to refactor code via the little-understood RegEx Replace functionality found in SQL…