In a previous article, we discussed Dynamic Data Masking (DDM) and how DDM helps to secure PII/PHI data from unprivileged users. The DDM feature is available in SQL Server 2016 onwards as well as Azure SQL Database.
This feature is useful to implement data security for existing data sets and future data. One of the best parts of this feature is that it doesn’t require any change in the application and data doesn’t change at the physical level. The data masking can be achieved by using any available built in functions. We discussed all these functions in previous articles.
In this article, we will discuss how we can use these built in functions to mask the data based on different data patterns, like social security number, credit card number, date of birth, email address, name, etc.
