Your AI Agent Is Quietly Corrupting Your SQL Files
AI agents writing T-SQL via PowerShell here-strings produce LF line endings, breaking SSMS and diffs.
SqlPackage, Synonyms, and the Third-Party Database Problem
You ask your AI coding agent to generate a T-SQL script. It writes the file. You open it in SSMS. And before you see a single line of SQL, you get this: If you’ve been…
Database Seeding: When to Hit the Table vs. When to Hit the API
You’ve got a new environment to stand up. Maybe it’s a fresh QA instance, maybe it’s a training environment someone just spun up, or maybe production got rebuilt after a disaster recovery test. Either way,…
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…
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…