Installing a SQL Server service pack failed with Error 1402. Could not open key: UNKNOWN\Components. System error 5. Here is the fix.
SQL SERVER – Query to Get the List of Logins Having System Admin (sysadmin) Permission
Many scripts online miss logins when listing sysadmin members. Why the common query is wrong, plus a correct one for logins with System Admin permission.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
Why an Encrypted Column Shows NULL on a Subscriber
An encrypted column shows NULL on a subscriber when the subscriber’s symmetric key doesn’t match the publisher’s key. This post reproduces the symptom with two demo databases, compares key_guid in both and shows the fix. It also explains what replication copies and what it leaves behind.
SQL SERVER – Log Shipping Copy Job Failure – The Password for This Account Has Expired
A reader’s log shipping copy job was failing with ‘The password for this account has expired’. Here is how we found the cause and fixed it.






