Learn how to use Always Encrypted to protect data, and understand where your certificates are stored.
- [Instructor] We're gonna jump right into our…Always Encrypted demo here.…And the first thing I'm gonna do,…I'm gonna use the Adventure Works 2016 CTP3 database,…and I'm gonna make a copy of our…Human Resources dot Employee table.…And I'm gonna do that by doing a select star into…a new table called Human Resources dot Employee AE…and that's gonna add 290 rows.…The next thing I'm gonna do is…go over to Object Explorer, and I'm going…to right click on that table.…You may have to hit refresh to see this table.…And I'm going to select Encrypt Columns,…and this is going to bring up the Always Encrypted GUI.…
You can do this via code, however…where you do need the GUI or some PowerShell…is when you decide where you want to put the master key,…and we'll talk a little about that on the next slide.…Two things I want to encrypt here are…National ID number and birth date,…so I check those, and I can choose…deterministic or randomized encryption here.…I'm going to use deterministic…for National ID because that's going to have…
- 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.