Dynamic Data Masking

External Article

Exploring SQL Server 2016 Dynamic Data Masking – Part Two - Masking and Exporting Data in Existing Tables

  • Article

Dynamic Data Masking allows you to obscure your confidential data column values at the database engine level for both new and existing SQL Server data. Being able to alter the definition of an existing column to add a masking rule makes it very simple to obscure your existing column values without even changing your application code.

2016-04-07

4,873 reads

Blogs

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Read the latest Blogs

Forums

Wahrung der Integrität der Prüfungsumgebung

By sergioblog066

Störsender für Prüfungssignale im Konferenzraum: Wahrung der Integrität der Prüfungsumgebung In der heutigen Zeit...

Subqueries II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Subqueries II

Distributed Monoliths

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distributed Monoliths

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code?

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)

See possible answers