Proving the Restore, Part 14: Getting the Script Out of the Procedure
The generator from builds a restore script into a variable. Getting it back out so someone can read it before running it seems like the easy part. PRINT @script returns the beginning of it. How…
Proving the Restore, Part 11: Generating the Restore Script
Everything so far establishes that a set of backups is coherent: complete stripes, a matching differential base, an unbroken log chain, one lineage, and a reachable target time. Writing the restore statements from that point…
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.