Microsoft SQL Server 2016 Express SP1 – Always Encrypted
In this post, I want to focus on the Always Encrypted security feature of SQL Server 2016 SP1, specifically with the Express edition. This post is motivated by a customer who was hoping to understand a bit more about the different encryption options, specifically column-level encryption, and whether or not the data remains encrypted when exported or backed up.
Which Encryption Options are Available for SQL Server 2016 SP1 Express?
As shown in the list of security features, you can see that the Express edition supports Row-level security, Always Encrypted, Dynamic data masking, and Auditing (most of which require SP1). The question I usually get is “I heard that SQL Server 2016 supports column-level encryption, but I only see row-level”. The reason why it’s not seen at first glance is because the Always Encrypted feature is what provides the column-level security.
Read the entire article here, SQL Server 2016 Express SP1 – Always Encrypted – Premier Developer
Via the fine folks at Microsoft