Dynamic Data Masking with MS SQL Server

Post created using SQL Server 2016 SP2 Lets say you have some users who need access to data in a database but you want to obfuscate sensitive data in certain columns. You can do this through masking the data by user roles. Masked data To do this is relatively simple. You need to add additional definitions … Continue reading Dynamic Data Masking with MS SQL Server