Andrew Pruski
dbafromthecold.com
SQL Server DBA originally from Wales but now exploring Ireland.
Blogging at dbafromthecold.com and has spoken at multiple events in Europe and the US.
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:
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. 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.
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. 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.
