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

From the creator

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ć: Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing different types of applications in .Net (C#) and SQL Server, ranging from standard line-of-business, image-processing applications to high performance and IoT applications. He's a regular speaker at various conferences and user group meetings, really likes to optimize slow SQL statements, analyze performance, and find unconventional solutions to difficult SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com). About MVPs: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are al

Published 2021-01-25 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.