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.
[01:49] What always encryption is important
[03:29] Always Encrypted v1 overview
[05:00] Always Encrypted v2 overview
[05:35] What is a secure enclave
[06: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 diﬀerent 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).
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram