Dynamic Data Masking

6 steps to a more secure SQL database

  • Article

Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]

5 (2)

2019-10-07

4,316 reads

Using SQL Compare with Dynamic Data Masking

  • Article

Dynamic Data Masking is an exciting new feature in SQL Server 2016, allowing DBAs to centrally set a mask that is returned for a table column instead of the actual data, limiting what information is returned to certain users in a consistent and reliable way. What’s more, Redgate SQL Compare safely and reliably handles your DDM changes. Data Platform MVP Steve Jones explains more.

2016-07-21

3,492 reads

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

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Read the latest Blogs

Forums

Read Only Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Read Only Files

Why A Query May be Faster the Second Time it Runs

By Kendra Little

Comments posted to this topic are about the item Why A Query May be...

OLE DB 0x80004005 connection error trying to run SQL HA Maintenance Plans

By sg_twinmaple

Hi, I'm getting a connection error when I try to run even the most...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers