Question : How to grant unmask permission to a user for one particular table and to one particular column within […]
Tag: dynamic-data-masking
Dynamic Data Masking Issue when Concatenating Fields
Question : You can reproduce the issue here: CREATE TABLE [dbo].[EmployeeDataMasking]( [RowId] [int] IDENTITY(1,1) NOT NULL, [EmployeeId] [int] NULL, [LastName] […]
SQL Server: can dynamic data masking be safe when providing a database backup?
Question : I have a SQL Server 2016 SP1 with data that I am ready to share with a partner […]
dynamic data masking read uncommited
Question : I have read about Dynamic Data Masking and one question is still in my mind. I am wondering […]
Problem with unmasking a database user during a sproc
Question : I am having an issue with a stored procedure that refreshes dynamic data masking on a database. This […]
Dynamic Data Masking Doesn’t Seem To Work Correctly With ISNULL
Question : Here is the code to reproduce the issue: CREATE TABLE [dbo].[EmployeeDataMasking]( [RowId] [int] IDENTITY(1,1) NOT NULL, [EmployeeId] [int] […]
SQL Server: can dynamic data masking be safe when providing a database backup?
Question : I have a SQL Server 2016 SP1 with data that I am ready to share with a partner […]
Using Dynamic Data Masking in SQL Server set Custom String
Question : I need to mask the data in the following table. For example, I need to mask the first_name […]