From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configure transparent data encryption - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure transparent data encryption
- [Instructor] Another option for encrypting the data at rest in user databases is to implement Transparent Data Encryption or TDE. Transparent Data Encryption applies realtime encryption and decryption of the data and log files used by a database and uses a database encryption key that is protected by a certificate issued by the server. Before we start, I need to make sure that I have a path on my computer set up to store some backup files. I've created a folder here on my C drive called TempSQL and I'll use this location but feel free to substitute a path on your own computer in the scripts that we're about to run. Back in SQL Server Management Studio, we begin by creating a master key and certificate in the master database on the server. I want to make sure that I'm using the master database and then we'll create that master key using the encryption by password method and we'll specify a strong password. Then we'll create a certificate and I'll name mine TDE Certificate, we need to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.