This was a joint session delivered by Alex Yates and Andrew Pruski (@dbafromthecold) at SQL Relay 2017 and SQL Bits 2018.

Abstract

Provisioning dev environments is often a slow, complicated and manual process. Often devs simply don’t have the diskspace.

You can solve many of the these problems with virtualisation technologies and source controlled powershell scripts.

We’ll show you how by talking you through:

DOCKER CONTAINERS
1. Defining containers
2. Configuring Windows Server 2016 to run containers
3. Running SQL Server containers
4. Creating custom container images
5. Sharing container images

REDGATE CLONES
6. Defining database clones
7. Masking data
8. Creating database images from backups or live databases

WINDOCKS

9. Containers and clones working together

The session will explain concepts via slides which will be backed up by demos.

Slides

References

• Running your first container
• Building custom container images
• Andrew Pruski’s “persisting data” series
• Summary of Andrew Pruski’s container series
• Redgate SQL Clone
• Redgate Data Masker
• Whitepaper: Data masking – What you really need to know before you begin
• WinDocks

Other talks

• DevOps 101 for data professionals – how your jobs will change
• Database version control and deployment – model or migration scripts
• Database DevOps Anti-Patterns
• Getting CI right for SQL Server
• My full speaker schedule

Support implementing Database DevOps

If you are looking for Database DevOps training or consultancy, DLM Consultants can help. We offer on-site consultancy as well as online workshops. Our full public workshops schedule is here.

To read more about our services or to contact us head to www.dlmconsultants.com.