SQL Server Always On Availability Groups and Database Master Keys: A Hidden Failover Pitfall (opens in new tab)

I recently came across an interesting case involving a client whose application used SQL Server symmetric keys to encrypt sensitive data. The database was hosted in an Always On Availability Group environment for high-availability and disaster-recovery. The interesting and challenging aspect of this setup is ensuring that the encryption and decryption remains intact after a […] L’article est apparu en premier sur .