Always Encrypted is a new method of security in SQL Server 2016, which separates encryption keys from the data itself. It also uses modern algorithms and integrates with HSMs to provide maximum security for your data.
- [Instructor] Always Encrypted was introduced…in SQL Server 2016 and Azure SQL Database…in the 2015 timeframe, and this is a feature designed…to protect sensitive data, like your credit card numbers…or medical information, and it allows clients…to encrypt that data within applications,…and most importantly, never reveal the encryption keys…to the database engine.…This means it provides a separation…of those who own the data, and can view it,…and those who manage the data, particularly the DBAs,…who would typically have access to the decryption keys.…On a traditional cell-level encryption,…they no longer have that scenario.…
This ensures database administrators…and other highly privileged users can't access the data,…removing another action of vulnerability.…It enables customers to confidently store sensitive data out…of their direct control.…They can encrypt data at rest and use it in storage,…in Azure or another cloud, to enable delegation…to third-parties or reduce security clearance requirements…for their own staff.…
- Designing row-level security
- Using views to implement row-level security in SQL Server pre-2016
- Data encryption
- Configuring Always Encrypted
- Dynamic data masking
Skill Level Beginner
SQL Server 2017: Linux, Docker, and macOSwith Adam Wilbert1h 44m Intermediate
SQL Server Performance for Developerswith Joey D'Antoni3h 44m Intermediate
Course software1m 3s
1. Row-Level Security (RLS)
2. Encryption in SQL Server
3. Data Masking in SQL Server
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.