SQL Server Science

Technical Articles for the DBA / Developer

Home » Page 17

Your Repository Is Just a Database

2026-05-13 · by Hannah Vernon · in Git for DBAs

If you’ve ever stared at a git tutorial and thought “why does this have to be so complicated?” — you’re not alone. Most git documentation is written by developers, for developers. It assumes you think…

“Now I Have the Full Picture” The Most Dangerous Lie Your AI Agent Tells You

2026-05-12 · by Hannah Vernon · in AI for DBAs, Hot Takes

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

2026-05-11 · by Hannah Vernon · in AI for DBAs, tools

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

2026-05-08 · by Hannah Vernon · in tools

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

2026-05-07 · by Hannah Vernon · in Hot Takes

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

2026-05-06 · by Hannah Vernon · in tools

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,…

« Previous 1 … 16 17 18 … 49 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • Privacy Policy

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2026 SQL Server Science