Want to learn more?
- An overview of Always Encrypted with example scenarios: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine
- Limitations of Always Encrypted: https://blogs.sentryone.com/aaronbertrand/t-sql-tuesday-69-always-encrypted-limitations/
- An overview of Dynamic Data Masking: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
- Limitations of Dynamic Data Masking: https://www.mssqltips.com/sqlservertip/4002/understand-the-limitations-of-sql-server-dynamic-data-masking/
- Transparent Data Encryption: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption-tde