Always Encrypted uses client-side encryption ensuring that data is encrypted both in flight and at rest. The encryption relies on keys that are never exposed to SQL Server, which means you can deploy your encrypted database to the cloud without the keys, which are shared only with trusted clients.
By leveraging secure enclaves in SQL Server 2022 and Azure SQL Database, Always Encrypted provides dramatic new capabilities. These include rich computation, pattern matching, and range operations over encrypted data.
You will learn:
- The basic Always Encrypted technology for client-side encryption with SQL Server
- How SQL Server and Azure SQL Database leverages secure enclaves to enable rich computation over encrypted data
- See live demos showing Always Encrypted in use with SQL Server and C#