SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Dynamic Data Masking Rss

Search for any content tagged dynamic data masking

   Items 1 to 17 of 17   
 

Moving Dynamic Data Masked Data to New Locations

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.  Read more...
By Steve Jones 2017/09/13 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 342 reads

Azure SQL Database - Dynamic Data Masking

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.  Read more...
By Additional Articles 2017/05/30 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,313 reads

Encrypting SQL Server: Dynamic Data Masking

Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.  Read more...
By Additional Articles 2017/05/16 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 2,916 reads

Dynamic Data Masking Feature in SQL Server 2016

Microsoft has introduced very impressive new security feature in SQL Server 2016 called Dynamic Data Masking (DDM).Dynamic Data Masking allow user to decide how much of the sensitive data to reveal with minimal impact on the application layer.   Read more...
By Pankaj Chakole 2017/01/05 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,226 reads

Using SQL Compare with Dynamic Data Masking

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.   Read more...
By Additional Articles 2016/07/21 | Source: Redgate | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,068 reads

Permissions and Security in Dynamic Data Masking

Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.  Read more...
By Steve Jones 2016/06/29 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 784 reads

Dynamic Data Masking

Deploy data masking as part of your SQL security strategy.  Read more...
By Ginger Keys 2016/05/16 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 2,027 reads

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

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.  Read more...
By Additional Articles 2016/04/07 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 4,624 reads

The Configured Data Masks for Dynamic Data Masking

Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.  Read more...
By Steve Jones 2016/04/06 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: (not yet rated) |  Discuss |   Briefcase | 1,348 reads

Datatypes and the Default Mask with Dynamic Data Masking

This article digs deeper into the ways that Dynamic Data Masking works with different data types.  Read more...
By Steve Jones 2016/03/23 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,350 reads

The Basics of Dynamic Data Masking

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.  Read more...
By Steve Jones 2016/03/15 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 2,827 reads

Exploring SQL Server 2016 Dynamic Data Masking – Part One

Greg Larson looks at how to hide the value of sensitive data by applying Dynamic Data Masking.  Read more...
By Additional Articles 2016/03/01 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 5,001 reads

SQL Server 2016: The Data Protection Version

Today Steve Jones looks at the security enhancements in SQL Server 2016  Read more...
By Steve Jones 2016/02/24 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Data Masking for Convenience

Steve Jones talks a bit about the new data masking feature in SQL Server 2016 and how useful it can be.  Read more...
By Steve Jones 2015/09/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

Understand the Limitations of SQL Server Dynamic Data Masking

Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.  Read more...
By Additional Articles 2015/09/03 | Source: MSSQLTips.com | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,288 reads

Learning Dynamic Data Masking

Information and links about Dynamic Data Masking in SQL Server 2016  Read more...
By Site Owners 2015/08/10 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: (not yet rated) |  Discuss |   Briefcase | 2,018 reads

Use Dynamic Data Masking in SQL Server 2016 CTP 2.1

SQL Server 2016 introduces a new security feature called Dynamic Data Masking (DDM). This tip describes its purpose, shows a brief example of how it works, lists some limitations, and notes how the feature has already changed since CTP 2.0 was first released in May.  Read more...
By Additional Articles 2015/07/15 | Source: MSSQLTips.com | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,614 reads
   Items 1 to 17 of 17