SQL Server Science

Technical Articles for the DBA / Developer

Home

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…

Stop Disabling Foreign Keys: Use a Topological Sort Instead

2026-05-20 · by Hannah Vernon · in troubleshooting

You inherit a PostgreSQL cleanup script. The very first line is:

Transact-SQL
1
SET SESSION_REPLICATION_ROLE TO REPLICA;

It works. Every table gets wiped clean, no FK errors, no complaints. Then one day somebody adds a new table to the schema,…

The psqlODBC Driver Is Eating Your RAISE NOTICE Messages

2026-05-19 · by Hannah Vernon · in troubleshooting

I just spent two days debugging a problem where my PowerShell script was logging 900 lines of output instead of 150. The script worked fine for months. Then someone added more tables to the process,…

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