Get 20% off all career paths from fullstack to AI
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
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