This was a joint session delivered by Alex Yates and Andrew Pruski (@dbafromthecold) at SQL Relay 2017 and SQL Bits 2018.
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:
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. Masking data
8. Creating database images from backups or live databases
9. Containers and clones working together
The session will explain concepts via slides which will be backed up by demos.
- 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
- 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.