SQLBits 2020

Solving the dev DB problem with Docker and dbaclone

Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.

DevOps promotes self-service access to usable, production-like dev/test environments – but so many data folks are lumbered 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 with 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.

Sander Stad's previous sessions

Streamlining Power BI with PowerShell

Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks.

Saying no is OK

In the high-demand IT field, professionals often struggle with overcommitment and work-life balance. This presentation, "Saying No is OK," offers practical insights and strategies for IT professionals to assertively manage their workload and protect their well-being. Learn the art of saying no, how to prioritize, and maintain professionalism while achieving a healthier work-life balance. Join us for a transformative session that will empower you to succeed while setting necessary boundaries.

Unveiling the magic of CI/CD for SQL Server using GitHub Actions

In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.

Github and Azure DevOps Duet - SQLBits edition

A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.

Battle tested project planning with Azure Devops boards

Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?

Start to See With tSQLt

Unit testing with databases is fairly new and is not yet embraced within database development. We'll learn how we can implement setup a database project, implement basic unit testing with tSQLt

Solving the dev DB problem with Docker and dbaclone

Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.

Alex Yates's previous sessions

DevOps 101 for Data Folks

An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.

Solving the dev DB problem with Docker and dbaclone

Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.

Containers and Clones: giant databases on tiny HDDs

Provision dev databases quickly and easily using containers and clones

Getting CI right for SQL server

Write SQL unit tests with tSQLt and automate them with VSTS.