SQL Server Science

Technical Articles for the DBA / Developer

Home

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

Git for SSDT Projects: Where It All Comes Together

2026-05-13 · by Hannah Vernon · in Git for DBAs

This is the post where everything clicks. Over the last eight posts, we’ve mapped git concepts to database analogies: repositories as databases, branches as database copies, merging as synchronization, tags as snapshots. You’ve got the…

Cherry-Pick Is Cross-Database INSERT…SELECT

2026-05-13 · by Hannah Vernon · in Git for DBAs

Sometimes you don’t want to merge an entire branch. You want one specific commit from another branch — one fix, one change, one feature — without bringing everything else along for the ride. DBAs do…

Tags Are Database Snapshots You Can Name

2026-05-13 · by Hannah Vernon · in Git for DBAs

Branches move. Every time you commit to a branch, it advances. That’s the point — branches are living, growing things. But sometimes you need to mark an exact point in time and know it will…

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