Learn how to use cell-level encryption to encrypt sensitive data in your database.
- [Instructor] In this demo, we're gonna demonstrate…cell-level encryption and the first thing we're gonna do…is create a master key within our database.…Cell-level encryption depends on a key hierarchy,…much like any other encryption methodology.…Here we're gonna create a master key.…And we're gonna encrypt it with a strong password.…Remember, the longer your password,…the harder it is to break the key.…In a production environment, you'd probably want to use…certificates for this, but here…we're just gonna use passwords.…On line five, we're gonna start creating an asymmetric key…with RSA 2048, and that's also gonna be encrypted…by a password.…
And since we've created this asymmetric key,…starting on line 11 we can create a symmetric key,…using the AES 256 algorithm, with encryption…by the asymmetric key that we just created.…So we'll go ahead and create that.…And then next on line 18, I'm gonna create a table…and this isn't something I'd probably do in production,…where I had unencrypted credit card information,…
- 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.