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_12

12. Considerations When Implementing Always Encrypted

Matthew McGiffen¹  

(1)

Bristol, UK

 

This is the last chapter on the basic version of Always Encrypted before we move on to look at the version with enclaves. I want to wrap up by looking at some additional items you may want to consider when planning to implement Always Encrypted.

In my opinion Always Encrypted is a great technology, but it’s not like TDE where you can pretty much flick a switch and expect everything to work just as it did before. At a minimum level you will need to modify connection strings for applications ...