Dynamic Data Masking (DDM) is an exciting new feature in SQL Server 2016 that means you can centrally set a mask that's returned for a table column, instead of the actual data.

This limits the information that's returned to certain users in a consistent and reliable way.

What’s more, Redgate SQL Compare now safely and reliably handles your DDM changes.

Data Platform MVP Steve Jones shows you how in this short video.

To find out more, read Steve’s blog post.

Learn more about SQL Compare