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

sql-login-syncer: Copy SQL Server Logins Without Losing SIDs or Passwords

2026-08-18 · by Hannah Vernon · in security, tools

The spent three posts building up to a practical conclusion: SQL Server maps database users to logins by SID, not by name, and any login you recreate from scratch gets a new SID. showed the…

Is Your SQL Server Using RC4 for Kerberos? Here’s How to Find Out

2026-06-24 · by Hannah Vernon · in security, tools

You probably haven’t thought about Kerberos encryption types recently. That’s fair; the protocol mostly “just works” and has for decades. But CVE-2026-20833 changed the calculus. Microsoft disclosed a Kerberos information disclosure vulnerability in January 2026…

Self-Hosting Forgejo on Windows Server Hyper-V Step-by-Step

2026-06-01 · by Hannah Vernon · in tools

A complete walkthrough for running Forgejo on Debian 13 inside a Windows Server Hyper-V VM, with Docker Compose, Let’s Encrypt TLS, GitHub repo mirroring, and automated backups to a Windows network share.

Schedule Jobs in Azure SQL Database with Azure Functions

2026-05-28 · by Hannah Vernon · in configuration, tools

You don’t get SQL Server Agent in Azure SQL Database. If you’ve been a DBA for any length of time, that sentence probably made you twitch. Agent is the workhorse that runs your index maintenance,…

Performance Studio: A Cross-Platform SQL Server Execution Plan Analyzer

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

You have a slow query. You pull the execution plan in SSMS. You stare at the arrows. Some are thick, some are thin. There’s a yellow triangle somewhere. You’re pretty sure the problem is “in…

Performance Monitor: Free SQL Server Monitoring That Doesn’t Phone Home

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

I spend a lot of time on this blog talking about tools. Some of them are good. Some of them are overhyped on LinkedIn. This one is neither overhyped nor underpowered. It’s the real deal….

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