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

Your Agent Forgets Everything. I Measured What I Forgot to Write Down.

2026-09-16 · by Hannah Vernon · in AI for DBAs

An agent session ends and the context is gone. Everything it learned about your environment, every approach it tried and discarded, every decision you talked through together, and whatever it was about to do next….

A Plan Analysis Skill That Refuses to Let You Cite Cost

2026-09-15 · by Hannah Vernon · in AI for DBAs

I have been testing the rules in my own T-SQL style guide against real instances, which means reading a lot of execution plans. Partway through, I started using Erik Darling’s sqlserver-query-plans plugin[1] for the reading….

Copilot Code Review and the 4,000 Character Limit

2026-07-29 · by Hannah Vernon · in AI for DBAs

Here is a fun way to lose an afternoon: carefully write coding standards into your repository’s .github/copilot-instructions.md, request a Copilot code review on a pull request that violates several of them, and watch the review…

Getting Your AI Agent to Actually Follow Your Instructions

2026-07-28 · by Hannah Vernon · in AI for DBAs

There is a special kind of frustration in watching an AI agent cheerfully do the exact thing your instructions file tells it not to do. You wrote the rule. The rule is right there. The…

We Fixed The Progress Bar: A Jetpack Boost Debugging Story

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

Last week I published a post about Jetpack Boost’s progress bar going backwards. That post was an analysis: what the code does, why the bar behaves oddly, and a commentary on misleading code comments. This…

Four Prompts to an Impossible Tesseract

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

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…

1 2 … 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