Transparent data encryption or always encrypted?

%3CLINGO-SUB%20id%3D%22lingo-sub-242912%22%20slang%3D%22en-US%22%3ETransparent%20data%20encryption%20or%20always%20encrypted%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242912%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fsecurity%2Fencryption%2Ftransparent-data-encryption%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETransparent%20Data%20Encryption%20(TDE)%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fsecurity%2Fencryption%2Falways-encrypted-database-engine%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAlways%20Encrypted%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bare%20two%20different%20encryption%20technologies%20offered%20by%20SQL%20Server%20and%20Azure%20SQL%20Database.%20Generally%2C%20encryption%20protects%20data%20from%20unauthorized%20access%20in%20different%20scenarios.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThey%20are%20complementary%20features%2C%20and%20this%20blog%20post%20will%20show%20a%20side-by-side%20comparison%20to%20help%20decide%20which%20technology%20to%20choose%20and%20how%20to%20combine%20them%20to%20provide%20a%20layered%20security%20approach.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20935px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44981i5D048FDC7F830EB8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22c107adfe-2f90-4a54-a2ba-41b75c63e32e.png%22%20title%3D%22c107adfe-2f90-4a54-a2ba-41b75c63e32e.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ERead%20about%20it%20in%20the%20Azure%20blog.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-242912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20%2B%20Storage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

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

 

They are complementary features, and this blog post will show a side-by-side comparison to help decide which technology to choose and how to combine them to provide a layered security approach.

 

c107adfe-2f90-4a54-a2ba-41b75c63e32e.png

 

Read about it in the Azure blog.

0 Replies