SQL Data Mask is the latest prototype to come out of the Foundry. It copies your database while anonymizing personal data. You can use it to mask your databases right now, free of charge. What we’ve been up to: Progress on SQL Data Mask is advancing quickly. Based on the feedback you’ve given us,... read more
If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce... read more
You can use SQL Doc’s command-line parameters to automate database documentation, but when you try to automate the process of documenting a group of databases on a server, they sometimes don’t give you enough control over your automated job. The GUI does offer far more settings but when you’re running an automated process, you... read more
Foundry is Redgate’s research and development division. We develop products and technologies for the Microsoft data platform. Each project progresses through Foundry’s four-stage product development process: research, concept, prototype and beta. At each stage, the Foundry team is exploring the scope and potential for Redgate to develop a product. We’ve just started researching inventory... read more
At the end of 2016, we interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools and what lessons he’d learned. The highlights make interesting reading. You describe the time before Redgate database automation as ‘truly the Wild West of database development’.... read more
Live streaming events is something that’s rather new to Redgate, the first one being SQL in the City back in December, which was a great success. So with the launch of our new tool SQL Clone looming, we thought we’d do it again. There’s good reason too. While meeting people face-to-face at events is... read more
We can use the SQL Compare Pro command line with PowerShell to automate the process of creating a new build script for a version of the database, from the object scripts in the VCS. However, what if we want to include static data in the build? This article describes how to the use the... read more
If you have a very large database, up to 2TB in size, SQL Clone will let you copy, or ‘clone’, that database many times, very quickly, making the full database available in multiple SQL Server instances across your development and test environments. And yet in each of these instances, the cloned database takes up... read more
As with any creative role, managers who are hiring for User Experience positions will often sift through a vast number of CVs and portfolios before a candidate even makes it through the door. As a potential employee it’s your job to impress, sell yourself to the company and most importantly give some insight into... read more
What’s SQL Data Mask? SQL Data Mask is the latest product from Foundry to be graduated to the prototype phase. It copies your database while anonymizing personal data. You can use it to mask your databases right now, free of charge, and there’s a full tutorial below. You can also look at the upcoming... read more
