Product articles SQL Provision
Approaches to masking email addresses
Chris Unwin explains the basic approaches to anonymizing email addresses, and shows how Data Masker can generate realistic email addresses, based on faked names, and even retain the correct distribution of email providers. Read moreMasking Dates in a Non-Production Database
Gerry Leith explores what’s required for the effective masking of dates and times in your data. Read moreHow to automatically provision sanitized data using SQL Clone, Data Masker and PowerShell
Chris Unwin describes a strategy, using data masking, cloned databases and PowerShell, which will allow you to sanitize data before provisioning test or development environments. Read more
SQL Server Database Provisioning: Getting Started with SQL Clone
Tony Davis takes a ‘first look’ at cloning databases with SQL Clone, reviewing some of the database provisioning challenges that we seek to overcome, explaining briefly how SQL Clone works, and then walking through a simple example of creating a clone from a live database. Read moreSQL Clone Quick Tip: Offloading DBCC checks
If you guard against database corruption by restoring backups to secondary server, licensed as per production, and then running DBCC CHECKDB integrity checks, then you might save a lot of restore time, and disk space, by offloading this task to a clone. Read moreDatabase provisioning from backups using SQL Clone
A step-by-step guide to creating an image from a database full backup, or from a full backup plus differential backup. Read moreUsing striped backups with SQL Clone
Can we use a striped backup as the source for a SQL Clone image? Yes we can! Read moreBackup and restore of a SQL Clone
What if you now do development work on a clone, but you to continue working on you own local clone while ‘disconnected’, such as when travelling? One simple option if the original database contains no private data, or the image has been masked, is to performance a normal backup and restore operations the clone, although you'll now be working with a normal, full-sized database. Read moreSQL Clone and backups protected with TDE – part 2
Steve Jones proves that SQL Clone can create a clone from a TDE-protected SQL Server database backup. Read moreRedgate Hub
-
Product Articles
Tips and how-to guides for Redgate products
-
University
Easy to follow video courses
-
Events
Join us online, or get sponsored
-
Forums
Ask, discuss, and solve questions about Redgate's tools
-
Community
Develop your skills and meet Redgate Advocates and Friends
-
Simple Talk
In-depth articles and opinion from Redgate's technical journal