5 Lessons Learned With SQL Always Encrypted

SQL Server 2016 (13.x), Azure SQL Database Azure SQL, Managed Instance, Azure Synapse Analytics (dedicated SQL pool only)

Microsoft introduced Always Encrypted with SQL Server 2016 as an approach to encrypting data at rest and in transit to protect personally identifiable information and financial transactions. Always Encrypted works by encrypting the data on the client side and hiding the encryption keys from the server. Without explicit permission and configuration, even database administrators cannot read the information stored in an encrypted column. This is obviously a significant step forward in security and allows users to confidently store information knowing only they control who can see it, whether it is in the cloud or on-premise.