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_2

2. Introducing Transparent Data Encryption

Matthew McGiffen¹  

(1)

Bristol, UK

 

In this chapter we begin to look at Transparent Data Encryption (TDE). TDE was introduced in SQL Server 2005 as a way to encrypt your data. It remains part of SQL Server and pretty much unchanged right up to the latest versions.

For a long time TDE was only available in the enterprise edition of the product, but from SQL 2019 you can use it in the standard edition also. That makes it a tool that many of us who use SQL Server can utilize without any additional price tag.

What Is TDE?

TDE is referred ...