In this demo you can learn how to build a masked set of data to move to a lower environment.
- [Narrator] So in this demo we're going to showcase…my favorite personal use case for dynamic data masking.…And that's masking data that you want to export…for a production to development data migration.…The first thing we're gonna do on line one here…is create a new data base called DDM_Demo.…So now that we've created the data base.…We're gonna go ahead and use it and create…this membership table here starting on line six.…You can see on line eight that we've masked…the first name column with the custom function.…We've masked phone number…with the default phone number function…and we've masked email with the default email function.…
So, we'll go ahead and create this table.…And then I'm gonna insert into the membership table…that I just created some data.…Here starting on line 13.…Then on line 18, I'm gonna create a new login…and a new user.…What this is going to do is to allow me to grant…a small set of permissions to this user.…I'm granting VIEW DEFINITION TO demoexport;…and I'm granting db_datareader and db_data writer…
- 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.