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 – 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 – Error: 26014, Severity: 16. Unable to Load User Specified Certificate
After a client changed the SQL Server certificate, the service would not start: Error 26014, unable to load User Specified Certificate. Here is how we fixed it.
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?
SQL SERVER – How Enable Transparent Database Encryption (TDE) for Database Mirroring?
hey incidentally wanted to enable Transparent Database Encryption (TDE) on their server and wanted me to guide on how to enable.
SQL SERVER – Transparent Data Encryption and Frequently Asked Questions
A banking DBA quizzed me about TDE on SQL Server 2008 R2. Here are the Transparent Data Encryption questions and answers from that 30 minute chat.