SQLBits 2018

Containers and Clones: giant databases on tiny HDDs

Provision dev databases quickly and easily using containers and clones
Provisioning dev environments is often a slow, complicated and manual process. Often devs simply don’t have the diskspace. And then there is GDPR.

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:

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

6. Defining database clones
7. Configuring the SQL Clone server
8. Creating database images from backups or live databases
9. Provisioning clones to a container in one click

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