Guest Post | Advt. | Query:

Redgate adds fast, repeatable data masking to its database provisioning solution

Cambridge UK, Wednesday, 28 February, 2018 – In another move to ease the burden of remaining compliant with the upcoming General Data Protection Regulation (GDPR), Redgate has enhanced its SQL Provision solution to make the masking of data even easier.

SQL Provision allows users to create copies of SQL Server databases using just MB of storage and mask any sensitive data. The virtual cloning technology of SQL Clone is used to create the copies, while Data Masker replaces sensitive data with realistic, anonymized data that preserves semantic integrity. The sanitized copies can then be used by development teams and testers to speed up development, accurately test code, and fix issues faster.

With legislation such as the GDPR and HIPAA requiring organizations to de-identify, pseudonymize or anonymize personally identifiable information used in the development process, the masking element is crucial.

The upgrade to SQL Provision enables a data masking set created in Data Masker to be selected during the provisioning process within SQL Clone in, literally, two clicks. This makes the process far quicker, shortens the workflow, and means provisioning is consistent, repeatable, and auditable.

The entire process can also be scheduled and automated using PowerShell so that, for example, the sanitized copies can be created overnight and instantly made available in the morning. Using this method, developers are always working with the latest version of the database, and compliance and privacy is built in by design.

The new feature was introduced because, while databases change over time, the nature of the data within them is fairly consistent. A column of credit card numbers, for example, will remain the same, as will a column with dates of birth. This is the kind of data that needs to be masked and, unless another column of sensitive data is added to a database, the masking set will still apply.

As Richard Macaskill, Redgate Product Manager, explains. “Once you’ve established which data needs to be masked and how, that won’t change unless you introduce a new subset of data, or make a major change to the database structure. So the requirement to be compliant with the GDPR actually brings with it the opportunity to introduce consistency and repeatability into the database provisioning process. And that, in turn, meets the demand to be auditable.”

With increasing legal requirements suggesting organizations should be building data privacy and protection into processes and systems by design and default, the latest release of SQL Provision is a big step in the right direction. It supports both the DevOps approach to working, while keeping compliance central to the process, creating a consented boundary between production and non-production environments.

The development team behind SQL Provision are now looking into aligning SQL Clone and Data Masker yet further to make the provisioning and masking of SQL Server databases even easier.

For further information, please contact:
Karis Brummitt, Product Marketing Manager, Redgate Software

Matt Hilbert, Technology Writer, Redgate Software
07564 778274

About Redgate Software
Redgate makes ingeniously simple software used by over 800,000 IT professionals and is the leading Microsoft SQL Server tools vendor. Redgate’s philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them to adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.

Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

…… ……. … …

……… …. …….

….. …… ………

……. ….. …….

.. ……. …….. 0

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!

.. ……. …….. .

buy! buy! CHEAP! Telefonie VoIP CHEAP! buy! buy! CHEAP!


……. ….. ……..


For the 2012 MLB period, we found an totals forecast Joao’s Renowned Over/Under João Zorro Gonçalves, Zcode Totals Pro, System of the time with progressions that have been successful over 98 98% ... We eventually perfected our over/under program ( Zcodesystemexclusive ), although it h-AS has brought years of investigation. Five Steps to Making a Winning MLB Method: 1. Execute appropriate cash management tools. 2. MLB rules that are comprehend. 3.Extensive testing back to make sure successful longterm results ...


There is always a challenge when you're dealing with the Foreign Exchange Market. That's just the nature of the beast. The best thing you can do is to learn about how the market operates as a whole so that you will be ready to meet these challenges. iq option penipu Never be misled by any profit gains in binary options. This is the number-one way traders end up losing their money and ultimately failing. Remember that the same things that make you laugh can make you cry in this market, and you can lose that $700.



Learning Polish has never been this fun and easy as with our podcasts Learn Polish with Polishpod101 Start today and become conversational in Polish in no time


The Best Website Agen Poker Resmi Terpercaya come join


Do you need edmonton phone systems service ? Call complete communications today!

……… ……… .


High-tech solutions for easy start-up of your IPTV/OTT-business



If you want to purchase not only one item, you have a chance to enjoy privileges. There is a sale’ tab on the site which offers a fantastic range of reduced counterfeit watches and accessories, such as sunglasses, cufflinks, watch straps and pens. Luxury Jewelry Replica At MCA.MN On Sale You get a 5% discount if you buy two pieces, this discount increases to 10% if you buy 4 pieces or more. There is free international shipping on all orders on this site. We also offer customers a free return anytime with a 100% money back guarantee.