Product articles Compliant Database Provisioning
Self-service and Delegation with SQL Clone 4 Teams
SQL Clone 4 introduces a new access control feature called Teams, allowing granular control over the SQL Server instances, images and clones to which each group of users has access. I’ll explain how Teams makes it easier to manage the safe distribution of database copies throughout the organization, to the various teams that need them Read more
Resolving Cross Database Dependencies in SQL Change Automation using Local Databases or Clones
How to avoid database build failures, caused by circular cross-database object references, by restoring or provisioning copies of all required databases to the development, build, or test SQL Server instance. Read moreWhat’s new in v6.3 of Data Masker for SQL Server
The first time you approach the task of data masking, it can seem daunting. You've identified your sensitive columns, but how do you decide on the best data masking strategy? Which rules do you need in your data masking set? Data Masker for SQL Server makes it easy to decide. Read more
Practical steps for end-to-end data protection
If you plan to make production data available for development and test purposes, you'll need to understand which columns contain personal or sensitive data, create a data catalog to record those decisions, devise and implement a data masking, and then provision the sanitized database copies. Richard Macaskill show how to automate as much of this process as possible. Read more
Dealing with Server Objects, Settings and Features when Provisioning Databases
If we want the behavior and performance of our test databases to mimic that observed in production, then we must consider not only the database but also the server. Grant Frtichey reviews the server-level objects, settings and features that we may need to consider, and then shows how to 'synchronize' the linked servers, user logins and SQL Agent jobs, as part of an automated provisioning process, using SQL Provision. Read moreHow to Provision a Set of Databases to Multiple Azure-based Servers
Grant Fritchey shows how to provision a group of interdependent databases, masked to protect sensitive or personal data, to each machine in an Azure-based test cell. Read moreSQL Provision and Azure SQL Database: Creating Local Development and Test Databases
As more businesses start to use cloud-based platforms, such as Azure SQL Database, as their primary database solution, they find that they still need to support on-premise workflows for development and test databases. This is a perfect task for SQL Provision. Read moreThe Database DevOps Challenges SQL Provision Solves
SQL Provision helps to accelerate the delivery of database changes, by enabling an organization to provide database copies, and the right data, to all parts of the deployment pipeline that need it, with a light footprint, and securely. Tony Davis explains how. Read moreSQL Provision offers users an easier way to manage, organize and make available masked copies of databases
Rebecca Edwards premieres the new SQL Clone 3.0 dashboard, and explains new features to make it easier to manage clones, view recent activity on them, and reset clones with the push of a button. Read moreCreating Multiple Masked Databases with SQL Provision
Chris Unwin explains how SQL Provision can create copies of multiple databases, each masked consistently, and deliver them as a group. This is useful when, for example, you are working with a Data Warehouse that contains several cross-database relationships. Read moreBuilding Better Test Data with SQL Provision
Steve Jones show how a team might use SQL Provision to build consistent, compliant, useful databases, on demand, for development and test environments. Read moreAutomatic Provisioning of Developer Databases with SQL Provision
Steve Jones shows a simple way to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process. Read moreSQL Provision adds fully integrated data masking
Karis Brummit announces SQL Provision, which combines SQL Clone's fast, lightweight database copying and centralized management of provisioning, with Data Maskers's ability to obfuscate sensitive or personal data, prior to distribution. Read moreCreate, protect and manage non-production databases with SQL Provision
SQL Provision allows users to create copies of SQL Server databases in seconds, using a fraction of disk space, and mask any sensitive data to help address data privacy and protection concerns. It serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from one central location, without blocking the team's development and release processes. 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 moreSQL Clone v2.4 – run scripts during image creation
SQL Clone 2.4 incorporates a new T-SQL script runner that the team can use to mask sensitive or personal data, or to modify security and other configuration settings, prior to creating a clone. Read moreSQL 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 moreHow Redgate use SQL Clone internally to provision databases
An Interview with the Redgate IT Manager to discover how SQL Provision is being used to implement a new database provisioning process. 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 moreBringing DevOps to the database – Moody’s Analytics and SQL Clone
Moody's Analytics had a constant need to provision database copies, particularly for the Test Engineers who needed to run multiple daily database integration and acceptance tests. SQL Clone reduced the time taken to deploy a database copy to minutes, instead of hours. Read moreProtecting production data in non-production environments
Grant Fritchey discusses the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment, and how SQL Provision can help you achieve this. Read moreNew permissions features brings access control to SQL Clone
SQL Clone permissions give you simple control over who can access SQL Clone, and what they can do with it. Read more
Basic data masking for development work using SQL Clone and SQL Data Generator
Richard Macaskill describes a lightweight copy-and-generate approach for making a sanitized database build available to development teams, using SQL Clone, SQL Change Automation and SQL Data Generator. 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 moreWhy is my clone so small?
How is it possible that the cloned databases could be so small and lightweight, and yet behave exactly like any normal database, complete with all the data? It sounds like magic, but it's not. It simply makes clever use of native Windows virtualization technology. Read moreSQL Clone: the aspirin for your database provisioning headaches
For teams who use a shared development database out of necessity rather than choice, SQL Clone might make the dedicated model viable for the first time. 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 moreSQL Clone and databases protected with TDE – part 1
Steve Jones proves that SQL Clone can create a clone from a SQL Server database that is protected by Transparent Data Encryption (TDE). Read moreA behind the scenes glimpse of SQL Clone
It has always been a difficult task to provision development and test environments so that they reflect as closely as possible what’s present in production. With the rise of containerization and Infrastructure as Code (IaC) technologies, some parts of this are becoming much easier. We can automate the process of spinning up and configuring new virtual 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