Dynamic Data Masking

Using SQL Compare with Dynamic Data Masking

  • Article

Dynamic Data Masking is an exciting new feature in SQL Server 2016, allowing DBAs to centrally set a mask that is returned for a table column instead of the actual data, limiting what information is returned to certain users in a consistent and reliable way. What’s more, Redgate SQL Compare safely and reliably handles your DDM changes. Data Platform MVP Steve Jones explains more.

Additional Articles

2016-07-21

3,492 reads

Exploring SQL Server 2016 Dynamic Data Masking – Part Two – Masking and Exporting Data in Existing Tables

  • Article

Dynamic Data Masking allows you to obscure your confidential data column values at the database engine level for both new and existing SQL Server data. Being able to alter the definition of an existing column to add a masking rule makes it very simple to obscure your existing column values without even changing your application code.

Additional Articles

2016-04-07

4,873 reads

Blogs

Drop Database Objects Practically Risk-Free!

By administrator

FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...

Lengthen a Primary Key–#SQLNewBlogger

By Steve Jones

Another post for me that is simple and hopefully serves as an example for...

Setup SQL Server Alert to get automatically notified of database blockings

By SQLPals

Suppose you want to or need to know anytime your SQL Server is experiencing...

Read the latest Blogs

Forums

Protecting Data Between Services

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Protecting Data Between Services

User Mapping Issues

By DHeath

I have a server that is version 12.0.6214.1 and here is my issue. I...

SQL browser and port number

By John Deupree

We have several new servers running SQL 2014.  Some servers are single instance servers...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers