Schedule

11:30 am – 12 pm Social/Networking

12:00 – 12:05 UG Updates

12:05 – 12:55 Presentation

Presentation Title

Solving the dev database problem with GitHub, Docker and dbaclone

Abstract

DevOps promotes self-service access to usable, production-like dev/test 

environments – but so many data folks are encumbered with shared 

development databases which are often inconsistent with production. It’s 

difficult to isolate the development of different features, so they are 

rolled together into big releases. It’s no wonder database deployments 

are often expensive, complicated and risky.

What if it was possible for developers to provision themselves a 

disposable, masked copy of last night’s production 64 TB database on 

their regular workstation, with limited storage, in a matter of seconds? 

What if it was as easy as “git clone f5”?

In this session attendees will learn to use GitHub, Docker, SSDT and 

dbaclone to unshackle themselves from “Wild West” dev databases 

and empower them to use modern branching techniques and Azure DevOps to 

continuously deliver their updates to production.

The result? Empowered developers who can deliver value in smaller 

batches, through significantly more regular and reliable deployments,

delivering value to users much more quickly.

More from the DevOps Flow series:

1. DevOps 101 for Data Folks:

   https://gist.github.com/Alex-Yates/efef91357c6bd0dc1fbe63f2eb464f68

2. Simple database deployments with GitHub, Azure DevOps Services and SSDT: 

   https://gist.github.com/Alex-Yates/43c7f4d51a651cd8b3dcdcb48843691f

3. Solving the dev database problem with GitHub, Docker and dbaclone:

   https://gist.github.com/Alex-Yates/8125be587e58863ad35e0845ab6ffd5a

4. Zero downtime database deployments

   https://gist.github.com/Alex-Yates/ac4c791bbd98eb3269f35db59cc30f88

Alex’s Bio

Alex Yates has been helping organisations to apply DevOps principles to their data since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. 

A keen community member, he co-organises Data Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.

Conference details:
https://zoom.us/j/3037207595?pwd=dkNzejFvZmRKeVcyemMwTmxZeHlEZz09

Meeting ID: 303 720 7595

Passcode: 725691

One tap mobile

+13462487799,,3037207595#,,,,,,0#,,725691# US (Houston)

+16699009128,,3037207595#,,,,,,0#,,725691# US (San Jose)