Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine. As a result, Always Encrypted provides a separation between those who own the data and can view it, and those who manage the data but should have no access.. GeoPITS brings you the comprehensive details of Always Encrypted's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | Yes | Yes |
| Version v2017 | Yes | Yes | Yes | Yes | Yes |
| Version v2016 | Yes | Yes 1 | Yes 1 | Yes 1 | Yes 1 |
| Version v2014 | |||||
| Version v2012 |
Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine. As a result, Always Encrypted provides a separation between those who own the data and can view it, and those who manage the data but should have no access.
You can find more details about this version here
Back to all features