Overview
Explore the intricacies of Transparent Data Encryption (TDE) in this 56-minute conference talk from the PASS Data Community Summit. Delve into the world of hacking and data security as Chris Bell exposes the transparency levels of TDE. Learn about various hacking tools, backup strategies, and the process of enabling and disabling TDE. Discover the implications of TempDB encryption, data at rest security, and the impact on backup compression. Gain insights into managing encryption keys and certificates, and understand the increased overhead associated with TDE implementation. Conclude with a comprehensive review of the key takeaways, equipping yourself with essential knowledge to enhance your database security practices.
Syllabus
Introduction
QA
Sponsors
Pathum
Big of the Hour
Welcome
Agenda
Chris Bell
What is Hacking
Tools
Backups
Backup Files
Search
Compress Backup
Restore Compressed Backup
Transparent Data Encryption
Enabling TDE
Creating Database Encryption Key
Database Encryption Status
Turning Off Encryption
TempDB Encryption
Data at Rest
Uncompressed Backup
Attempting to Restore
Encrypting the Temp DB
Increased Overhead
Backup Keys and Certificates
Backup Compression
Final Notes
Quick Review
Taught by
PASS Data Community Summit