SQL Server Science
Technical Articles for the DBA / Developer
Home » AI for DBAs » Page 2

Sharing GitHub Copilot Instructions Across Repos and Teams

2026-05-22 · by Hannah Vernon · in AI for DBAs

Your AI assistant starts every conversation as a blank slate. It doesn’t know your team uses COALESCE instead of ISNULL. It doesn’t know your naming conventions, your commit message format, or the three anti-patterns that…

“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.

Teaching Your AI Assistant to Remember: Session Checkpoints for Multi-Day Work

2026-05-01 · by Hannah Vernon · in AI for DBAs

If you’ve used an AI coding assistant for anything beyond a quick one-off question, you’ve hit the wall: the conversation context runs out. You start a new session, and the assistant has no idea what…

A Junior DBA’s Field Guide to This Series: What Your Mentor Forgot to Explain

2026-04-23 · by Hannah Vernon · in AI for DBAs

A companion guide for junior DBAs navigating the ALTER DBA ADD AGENT series. Maps the vocabulary walls, production safety gaps, and confidence calibration challenges that experienced readers won’t even notice.

SQL Server Patching Pre/Post Checks with AI

2026-04-23 · by Hannah Vernon · in AI for DBAs

Generate matched pre-patch and post-patch validation scripts with AI for safe SQL Server patching.

« Previous 1 2 3 … 10 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
  • Blog Series
    • Backup & Recovery from First Principles: Series Contents
    • Database as a Versioned Contract: Series Contents
    • Extended Events in Production: Series Contents
    • Git for DBAs: Series Contents
    • How SQL Server Stores Data: Series Contents
    • Logins, SIDs, and Kerberos from First Principles: Series Contents
    • Proving the Restore: Series Contents
    • T-SQL Style Guide, Tested: Series Contents
    • The UNKNOWN Problem: NULL Traps in T-SQL, Series Contents
    • Undocumented Changes in SQL Server 2022 and 2025: Series Contents
  • 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