I’ve deployed several SQL Server Always On Availability Groups in the past with high availability being the primary requirement. In some environments, there is a requirement to protect sensitive data for security and compliance reasons. Back in 2013, I had a customer who wanted to implement Always On Availability Groups for their databases. They were moving their […]
PostSQL Server Encrypted Backups: Transparent Data Encryption or Backup Encryption
This particular question came up while I was delivering a workshop last week on the new features in SQL Server 2014. Since transparent data encryption has been available since SQL Server 2008, why would I still need the backup encryption feature? For one, transparent data encryption is an Enterprise Edition-only feature whereas backup encryption exists in […]