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

3. Setting Up TDE

Matthew McGiffen1  
(1)
Bristol, UK
 

Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In the previous chapter we looked at what TDE is and how it works.

In this chapter we go through the steps of setting TDE up. You can set up TDE when you first create a database, or you can apply it to an existing database. In the latter case, once TDE has been enabled, it will encrypt your existing data in the background. In either case the steps are the same.

Creating the Keys and Certificate

The first step in setting up TDE is ...

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.