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_21

21. Other Methods of Column Encryption

Matthew McGiffen¹  

(1)

Bristol, UK

 

We’ve talked a lot in this book about using Always Encrypted to encrypt columns of data, and in general I feel that should be the default tool you choose when wanting to perform such actions. SQL Server does however have other methods you can use to encrypt data and has done since the 2005 version of the product. In my opinion these older methods are less secure and more limiting to work with than Always Encrypted – but you may have edge cases where you want to use them. As such we’ll cover them ...