Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example

Availability Groups are fantastic for High Availability/Disaster Recovery solutions, and I’m sure that fellow DBAs will agree with me. However, there will be times when we must consider certain precautions and extra steps carefully to avoid unwanted surprises. For instance, any Secondary Replica becomes the current Primary Replica for whatever reason, and our goal is to not let it happen.

CodingSight-Dealing with encryption of databases in an AlwaysOn availability group scenario
Read More