Question : You can reproduce the issue here: CREATE TABLE [dbo].[EmployeeDataMasking]( [RowId] [int] IDENTITY(1,1) NOT NULL, [EmployeeId] [int] NULL, [LastName] […]
Tag: data-masking
Dynamic length obfuscation method in T-SQL
Question : I would like to obfuscate (scramble) sensitive data from a SQL Server database, but in the way which […]
How does my system understand if data got masked?
Question : I was trying to understand the difference between encryption and masking Below statement says that real data replaced […]
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] […]
Scrubbing sensitive data
Question : I am looking for an automated solution to scrub sensitive data from my prod environment to my DEV […]
Dynamic length obfuscation method in T-SQL
Question : I would like to obfuscate (scramble) sensitive data from a SQL Server database, but in the way which […]
Can’t create indexed view against table with masked columns
Question : I am trying to create an index on a view that references a table with a masked column […]
SQL Data Masking a copy of data for backup
Question : I need to send a database backup to a vendor for an upgrade, and somehow need to mask […]