Transparent data encryption or always encrypted?
Transparent Data Encryption (TDE) and Always Encrypted are two different encryption technologies offered by SQL Server and Azure SQL Database. Generally, encryption protects Always Encrypted protect data from unauthorized access in different scenarios.