SQL Server Science

Technical Articles for the DBA / Developer

Home

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…

Rebase Is ALTER TABLE on Your Commit History

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

Rebase is where most DBA git tutorials hit a wall. The explanations get abstract. Diagrams appear with arrows pointing in confusing directions. People start arguing about when to use it. Here’s the DBA translation: rebase…

Stash Is Just a Temp Table for Your Changes

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

You’re halfway through modifying a stored procedure when your phone rings. Production is down. You need to switch to main and fix something immediately. But you can’t switch branches with uncommitted changes — or if…

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