Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: dynamic-data-masking

How to grant Unmask permission to a user at table level and column level in sql server?

By adminPosted on November 15, 2022

Question : How to grant unmask permission to a user for one particular table and to one particular column within […]

Dynamic Data Masking Issue when Concatenating Fields

By adminPosted on March 27, 2022

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?

By adminPosted on February 26, 2022

Question : I have a SQL Server 2016 SP1 with data that I am ready to share with a partner […]

dynamic data masking read uncommited

By adminPosted on November 15, 2021

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

By adminPosted on June 17, 2021

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

By adminPosted on April 8, 2021

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?

By adminPosted on October 1, 2020

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

By adminPosted on April 5, 2020

Question : I need to mask the data in the following table. For example, I need to mask the first_name […]

Recent Posts

  • Help me define the tables in this scenario
  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding