With security being one of the highest concerns when it comes to your data assets, new features and improvements in this area are always a hot topic! In his new article for TechTarget Rick Heiges, DB Best Principal Solutions Architect, talks about Dynamic data masking, one of many new security features coming in SQL Server 2016.
Dynamic Data Masking essentially displays characters instead of real data to non-privileged users.The data is not being stored as masked values. It is also in the Azure SQL database V12 preview.
As with anything, there are pros and cons with this approach. It is another tool in the toolbelt to help keep data secure. Combining DDM with other security features may be the right solution for your situation.
Click here to enjoy the full article.
