From the course: SQL Server 2022 Administration
Join today to access over 24,900 courses taught by industry experts.
Understand data masking - SQL Server Tutorial
From the course: SQL Server 2022 Administration
Understand data masking
So among all the ways you can protect data in your SQL Server, one of them is data masking. So I can block access to rows, I can block access to columns, I can encrypt data, but what if I need to see some portion of data but not necessarily reveal all of said data? And that's what data masking is all about. And it'll make more sense here when we walk through this demo. So in the WideWorldImporters database, I'm just going to make a new query, there is a column in the people table that contains email. So if I say select all from Application.People and I hit run, you'll notice over here that there's a login name that contains the email of that particular person. And while that's not necessarily super sensitive info, you can mask email addresses so that someone could see a little bit about it, but not see the whole thing. So it's sort of like when you call the bank and they say, "Oh, is this the credit card ending in 1, 2, 3, 4," they can see the last four of your credit card. They can't…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.