In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.
2019-02-07
2,794 reads
Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking.
2018-11-27 (first published: 2018-10-30)
4,920 reads
The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you were too shy to ask.
2018-01-05
3,734 reads
In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They're pleased to say this version of the prototype is now available - here are the details.
2017-05-24
2,809 reads
SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.
2017-05-10
4,085 reads
This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.
2017-05-08
3,810 reads
The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.
2017-04-24
3,252 reads
Faisal,I have no problems exporting and importing registry entries for Registered Servers X but it only works for the same login. For example if I move the registrations ti another server, but I login to both as the same domain login. This article too shows export and import working as the same Windows login. Are […]
2005-05-26
why wouldn't you just use enterprise manager? this works fine for me. //create objects SQLDMO.SQLServer2 s = new SQLDMO.SQLServer2Class(); SQLDMO.Backup2 b = new SQLDMO.Backup2Class(); SQLDMO.Restore2 r = new SQLDMO.Restore2Class(); //db name string d = "empty"; //db owner - needed to get the old logical file names below string o = "dbo"; //backup file string f […]
2005-05-20
Hi All Is any body can help me out to solve this following T-SQL please...T-SQL:SELECT a.name as UserName, b.name as Rolename FROM sysusers a, (SELECT name FROM sysusers b WHERE (b.name NOT LIKE 'db%') AND (b.name NOT IN ('guest', 'public')) AND (b.uid = gid)) b WHERE (a.name NOT LIKE 'db%') AND (a.name NOT IN ('guest', 'public')) […]
2005-05-20
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers