SQL Server Science

Technical Articles for the DBA / Developer

Home

Performance Studio: A Cross-Platform SQL Server Execution Plan Analyzer

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

You have a slow query. You pull the execution plan in SSMS. You stare at the arrows. Some are thick, some are thin. There’s a yellow triangle somewhere. You’re pretty sure the problem is “in…

Performance Monitor: Free SQL Server Monitoring That Doesn’t Phone Home

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

I spend a lot of time on this blog talking about tools. Some of them are good. Some of them are overhyped on LinkedIn. This one is neither overhyped nor underpowered. It’s the real deal….

The Progress Bar That Goes Backwards: A Jetpack Boost Source Code Archaeology

2026-05-25 · by Hannah Vernon · in Hot Takes, tools

You click “Regenerate Critical CSS.” The progress bar crawls forward: 20%, 30%, 40%. Then it drops to 20%. Climbs back to 50%. Drops to 35%. Eventually it hits 100%, and you exhale. Then it starts…

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…

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…

“The Numbers Are Wild”: Anatomy of a LinkedIn Tech Hype Post

2026-05-21 · by Hannah Vernon · in Hot Takes, Professional Development

A post showed up in my LinkedIn feed last week. It had all the hallmarks: short punchy sentences, each on their own line. Dramatic pauses between claims. A number so impressive it demanded an emoji…

1 2 … 36 Next »

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • 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