SQL Server has many great features, but sometimes they don't always work nicely together and this is the case with Transparent Data Encryption and Backup Compression. However in SQL Server 2016, Microsoft announced that they can work together and in this