Grant Fritchey
scarydba.com
Grant Fritchey, SQL Server MVP, works for Redgate Software as a Product Advocate. He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server Query Performance Tuning (Apress).
SQLBits 2017
Faster Provisioning with SQL Clone
Find out how the new SQL Clone enables self-service easy automation of database copies, near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.
Database provisioning requests are the bane of many DBA's working lives. Developers want to work with realistic data, DBAs want to protect Production and secure data.
But copying databases for development and test is a job that gets "delegated up"; DBAs, IT Managers, those with the keys to Production find themselves performing the task, and the development team is often blocked while it takes place.
The same people are often responsible for ensuring the copy is appropriate for the environment (permissions, configuration data, sensitive data), so have to perform semi-manual tasks and maintain brittle scripts to do so.
In this session Redgate's Grant Fritchey shows how new tool SQL Clone enables self-service or easy automation of database copies and is near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.