Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

M. McGiffenPro Encryption in SQL Server 2022https://doi.org/10.1007/978-1-4842-8664-7_16

16. Rich Querying with Always Encrypted Enclaves

Matthew McGiffen¹  

(1)

Bristol, UK

 

In this chapter, we’re going to look at the extra querying capabilities available when you’re using Always Encrypted with secure enclaves. Alongside that we’ll also look at indexes on columns encrypted with randomized encryption, functionality that wasn’t available before for very logical reasons we’ve already discussed.

The new functionality is often referred to a rich querying. Remember that with the basic version of Always Encrypted the only comparisons that could be carried out with ...