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…
ADO Doesn’t Mean What You Think It Means
You’re in a meeting. Someone says “ADO.” Your brain — conditioned by 20+ years of muscle memory — immediately conjures up connection strings, recordsets, and ADODB.Connection. Then you realize they’re talking about a CI/CD pipeline….
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,…
Diplomacy Is a Feature, Not a Bug
I was reviewing some data export files the other day when a colleague flagged a problem. One of the rows in a CSV file was misaligned — columns shifted, extra fields appearing where they shouldn’t….
Pick a Convention and Stick With It
You know what’s worse than a bad naming convention? Two naming conventions in the same database. I ran into this last week while writing a verification query for a PostgreSQL database. The query is a…