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 – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore
A client’s security patch for a SQL 2005 clustered instance failed with Error 29527, unexpected error in datastore. The setup log pointed to the cause.
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.
SQL SERVER – Why Does Encrypted Column Show NULL on Subscriber?
Replication between SQL Server 2016 instances worked, but an Encrypted Column showed NULL on the subscriber. Here is why, and how to replicate encrypted data.
SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate
A clustered instance would not start: Error 26014, unable to load user-specified certificate. What the ERRORLOG showed and how we got SQL Server running again.
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.