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_10

10. Limitations with Always Encrypted

Matthew McGiffen¹  

(1)

Bristol, UK

 

In the previous chapters we’ve looked at how Always Encrypted works, how to set it up, and how to work with it in practice.

Along the way we’ve seen a few restrictions, such as the need to use BIN2 collations for text-based columns or the requirement to use parameter-based queries against encrypted columns. There are a number of other limitations, but on the whole these aren’t representative of an incomplete or poorly implemented technology. Rather, they are the natural consequences of the type of ...