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_9

9. Encrypting Existing Data with Always Encrypted

Matthew McGiffen¹  

(1)

Bristol, UK

 

So far, we’ve just looked at the situation where you implement Always Encrypted for a new database. In many cases, however, you’re likely to be wanting to implement Always Encrypted for existing applications. Key to that will be being able to encrypt existing data.

As we’ve seen, one of the fundamentals of Always Encrypted is that SQL Server itself never has access to the unencrypted values of your data, and it doesn’t have access to the unencrypted Column Encryption Key. As such it’s not ...