© 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_1

1. Purpose of Encryption and Available Tools

Matthew McGiffen1  
(1)
Bristol, UK
 

SQL Server has had the native ability to encrypt data since SQL Server 2005. This included functionality that could be used to encrypt individual items and columns of data as well as the Transparent Data Encryption (TDE) feature which was available with the enterprise edition of SQL Server and could be used to encrypt all data where it is stored on disk. We then didn’t see significant additions to the features available for encryption until 2016 when Microsoft added Always Encrypted for column ...

Get Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.