Overview
Explore the intricacies of Always Encrypted technology in this comprehensive conference talk from the PASS Data Community Summit. Delve into the inner workings of Always Encrypted, comparing its advantages and disadvantages to other security technologies. Learn about SQL Server 2016's built-in features and security enhancements, including the implementation of SA password rotation. Gain insights into key management, including Column Master Key storage and Column Encryption Key types. Understand the various roles involved in key management and discover RDBMS security features across different editions. Enhance your knowledge of data security and encryption techniques to better protect sensitive information from potential hackers.
Syllabus
Intro
Technical Assistance
SQL Server 2016: Everything built-in
SQL Server 2016 - security enhancements
Challenge - Implementation of SA password rotation
Definitions - Keys
Column Master Key storage
Column Encryption Key (CEK) Types
Key Management Roles - who does what?
RDBMS Security Features by Edition
Taught by
PASS Data Community Summit