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

Can You Delete That Certificate? The Store Will Not Tell You.

2026-09-17 · by Hannah Vernon · in security

There is a certificate in LocalMachine\My on one of your SQL Servers. Nobody knows what it is for. The subject is unhelpful, it was issued before you started, and the person who installed it has…

Your Agent Forgets Everything. I Measured What I Forgot to Write Down.

2026-09-16 · by Hannah Vernon · in AI for DBAs

An agent session ends and the context is gone. Everything it learned about your environment, every approach it tried and discarded, every decision you talked through together, and whatever it was about to do next….

Your Repository Is Just a Database

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

If you’ve ever stared at a git tutorial and thought “why does this have to be so complicated?” - you’re not alone. Most git documentation is written by developers, for developers. It assumes you think…

Branches Are Just Database Copies You Can Merge Back

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

You’ve just finished your first commit and you’re feeling good. Then someone says “create a branch” and the confusion starts. Developer tutorials talk about branches like they’re some abstract computer science concept. They’re not. A…

Merging Is Like Synchronizing Two Databases

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

You’ve created a branch. You’ve made changes. Now you need to bring those changes back into main. In the DBA world, this is a problem you’ve already solved a hundred times - you just called…

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…

1 2 Next »

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
  • 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