SQL Server Science
Technical Articles for the DBA / Developer
Home » dba-tools » Page 2

Pull, Push, Fetch - It’s Just Backup and Restore Over a Network

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

So far, everything we’ve done has been local. Your repository lives on your machine, your branches are on your machine, your commits are on your machine. That’s fine for solo work, but the real power…

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…

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…

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…

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…

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…

« Previous 1 2

Search

Categories

  • AI for DBAs
  • announcements
    • events
  • basics
    • localization
  • configuration
  • Data Architecture
  • DMVs
  • documentation
  • extended-events
  • Git for DBAs
  • High Availability
  • Hot Takes
  • Internals
  • maintenance
    • patching
  • Opinion
  • performance
  • PostgreSQL
  • Professional Development
  • recovery
  • reporting
  • ROLLBACK;
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
    • wsus
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Blog Series
    • Backup & Recovery from First Principles: Series Contents
    • Database as a Versioned Contract: Series Contents
    • Extended Events in Production: Series Contents
    • Git for DBAs: Series Contents
    • How SQL Server Stores Data: Series Contents
    • Logins, SIDs, and Kerberos from First Principles: Series Contents
    • Proving the Restore: Series Contents
    • T-SQL Style Guide, Tested: Series Contents
    • The UNKNOWN Problem: NULL Traps in T-SQL, Series Contents
    • Undocumented Changes in SQL Server 2022 and 2025: Series Contents
    • Work That Flows: Kanban for DBAs: Series Contents
  • 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