Logins, SIDs, and Kerberos from First Principles, Part 3: Migrating Logins Without Losing Them
Server migrations have a predictable failure mode: the databases restore perfectly, the application connection strings are updated, and then nothing can log in. Or worse, everything can log in but half the database users are…
Logins, SIDs, and Kerberos from First Principles, Part 2: The Vanishing Service Account
Years ago at a previous employer, I wrote a fleet-sweep script that searched every SQL Server instance in the estate for a specific service account, by name and by a known-bad SID. I no longer…
Logins, SIDs, and Kerberos from First Principles, Part 1: What a SID Actually Is
Ask SQL Server who you are and it will answer with a name. Ask it to make a decision about you, though, and it uses something else entirely: a security identifier, or SID. Names are…
Isolation Is a Contract: Multi-Tenant Data Boundaries
This is the last post in the series, and it is about the promise with the least tolerance for being broken. Most contract violations cost you a bug report or an awkward migration. This one…
Generating Compliance Evidence with AI
Generate SOX, PCI-DSS, and HIPAA audit evidence with AI from your actual SQL Server configuration.