SQL Server Science

Technical Articles for the DBA / Developer

Home

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,…

I Shaved 156 MB Off My Blog by Converting PNGs to WebP

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

I just shaved 156 MB off my blog. Not the database, not the theme, not some plugin audit. The images. The Problem Nobody Talks About If you use AI to generate featured images for your…

Two Spaces After a Period: The Hill I Will Die On

2026-05-15 · by Hannah Vernon · in Hot Takes

I’m going to say something controversial in the year 2026, and I don’t care who it offends: You should put two spaces after a period. There. I said it. Come at me. The “One Space”…

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