SQL Server 2019 Always Encrypted: The Searchable Encryption! | Data Exposed: MVP Edition

Always Encrypted in SQL Server 2019 is now in its second iteration which has added the ability to do pattern matching searches on encrypted data with the use of a technology called secure enclaves. In this episode with Mladen Prajdić, we'll take a short look at what's needed to make this work, how it works, and how it can benefit your organization for more secure data practices.

0:00 Show begins
0:36 Introduction
1:49 What always encryption is important
3:29 Always Encrypted v1 overview
5:00 Always Encrypted v2 overview
5:35 What is a secure enclave
6:45 Always Encrypted V2
11:05 Always Encrypted V2 - do in-place encryption
14:31 Always Encrypted V2 - do rich computations, pattern matching
16:26 What is supported

About Mladen Prajdić:

About MVPs:

📌 Let's connect:


🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #AlwaysEncrpted #MVPTuesday #MVPBuzz

[galrickgak]

Hello. Any chance we can get a hold of the slide?