Skip to content

Instantly share code, notes, and snippets.

@Alex-Yates
Created May 4, 2017 12:44
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save Alex-Yates/09a17a2ed8df230e77e6827194ce49f5 to your computer and use it in GitHub Desktop.
Save Alex-Yates/09a17a2ed8df230e77e6827194ce49f5 to your computer and use it in GitHub Desktop.
Session abstract for SQL Relay
Title:
How to provision n >TB virtual SQL Server environments from scratch in seconds on a laptop with limited diskspace using containers and clones
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 and source controlled powershell scripts. We'll show you how by talking you through:
DOCKER CONTAINERS (virtual servers)
1. Defining containers
2. Configuring Windows Server 2016 to run containers
3. Installing the docker engine
4. Pulling/Pushing SQL images from/to the docker repository
5. Running SQL Server containers
6. Committing new SQL Server images
7. Exploring 3rd party options to run containers on previous versions of Windows Server (real world example)
REDGATE CLONES (virtual databases)
8. Defining clones
9. Configuring the SQL Clone server
10. Creating database images from backups or live databases
11. Provisioning clones to a container in one click
12. Provisioning clones in PowerShell - on a loop
The session will explain concepts via slides which will be backed up by demos (and music).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment