Skip to content

Instantly share code, notes, and snippets.

@dbafromthecold

dbafromthecold/PruskiYatesRelayAbstract

Forked from Alex-Yates/PruskiYatesRelayAbstract
Last active May 10, 2017 08:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save dbafromthecold/4eade549cf08a6782b01237ef46aa2dd to your computer and use it in GitHub Desktop.
Save dbafromthecold/4eade549cf08a6782b01237ef46aa2dd to your computer and use it in GitHub Desktop.
Download ZIP
Session abstract for SQL Relay
Raw
PruskiYatesRelayAbstract
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 to host a full production dataset locally.
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 (virtual databases)
6. Defining 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
10. Provisioning clones in PowerShell - on a loop
The session will explain concepts via slides which will be backed up by demos (and music).
@dbafromthecold
Copy link
Author

I've updated my section and added a bit to the abstract definition.

I also removed my section talking about 3rd party tools, I don't think we would have time but it could be useful to mention an alternate to RedGate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment