SQL Server Science
Technical Articles for the DBA / Developer
Home » claude

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.

How This Series Was Written: A DBA and an AI Walk Into a Terminal

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

This entire blog series was co-written with an AI coding agent. Here’s the transparent, behind-the-scenes story of how it was produced.

The DBA’s Blind Spot: Why AI Coding Agents Are Coming for Your Workflow

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

AI coding agents like GitHub Copilot CLI aren’t just autocomplete they read your files, run commands, and iterate. Here’s why DBAs can’t afford to ignore them.

ALTER DBA ADD AGENT: Practical AI for Database Professionals

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

A practical guide to using AI coding agents for SQL Server database administration. 18 posts covering T-SQL, monitoring, security, migrations, and more.

Part 2: When the AI Code Reviewer Finds Bugs the Optimizer Didn’t

2026-03-20 · by Hannah Vernon · in DMVs, performance, t-sql

In Part 1, I walked through an interactive session with GitHub Copilot CLI where we optimized a production T-SQL function — cutting memory grants by 80% and logical reads by 73%. I thought we were…

Can GitHub Copilot Optimize Your T-SQL? I Put It to the Test

2026-03-20 · by Hannah Vernon · in DMVs, performance, t-sql

I’ve been curious about how well AI coding assistants handle real-world T-SQL optimization — not textbook examples, but production code with system DMVs, Availability Groups, and windowed functions. So I pointed GitHub Copilot CLI at…

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • performance
  • Professional Development
  • recovery
  • reporting
  • 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