Schedule Jobs in Azure SQL Database with Azure Functions
You don’t get SQL Server Agent in Azure SQL Database. If you’ve been a DBA for any length of time, that sentence probably made you twitch. Agent is the workhorse that runs your index maintenance,…
Four Prompts to an Impossible Tesseract
It’s Friday afternoon. I have an AI coding agent open (Claude, via the Copilot CLI), and I’ve been using Google’s Gemini to generate featured images for blog posts all week. So I decide to try…
“Now I Have the Full Picture” The Most Dangerous Lie Your AI Agent Tells You
AI agents confidently say “Now I have the full picture” but they can’t know what they’re missing. Here’s what can go wrong when you let an agent run things unsupervised.
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.
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,…
SSRS and Multi-Subnet Failover: The Connection String That Doesn’t Exist
SSRS has no way to specify MultiSubnetFailover=True in its ReportServer database connection. Here’s how to automate SSRS reconfiguration after an AG failover across subnets using rsconfig.exe, sp_update_jobstep, and a SQL Agent alert.