Rob Richardson

Database DevOps with Containers

Stop letting database environments slow your team down. Learn to build an automated pipeline that delivers safe, production-like data inside a container.

Database DevOps with Containers
#1about 4 minutes

Defining the core principles of a DevOps pipeline

A standard application DevOps pipeline focuses on reliability, consistency, and cost, with source control serving as the single source of truth.

#2about 4 minutes

Understanding the unique challenges of database DevOps

Unlike applications, the production database is the master copy, requiring a pipeline to safely bring production data into non-production environments.

#3about 3 minutes

Preparing production data for development environments

Safely use production data by anonymizing private information, sanitizing secrets, and shrinking its size while preserving its unique characteristics.

#4about 5 minutes

How containers differ from virtual machines

Containers virtualize the operating system for greater efficiency, while virtual machines virtualize the underlying hardware.

#5about 7 minutes

Exploring the Docker ecosystem and image layers

The Docker ecosystem uses a Dockerfile to build a layered, immutable image which is then run as a lightweight, isolated container.

#6about 4 minutes

Using SQL Server containers for dev and test

While production databases may run on VMs or as a service, containers provide an ideal, ephemeral environment for development and testing.

#7about 5 minutes

Building a dev-safe database image with a Dockerfile

A multi-stage Docker build can restore a production backup, run a transformation script, and package only the sanitized data into a clean final image.

#8about 3 minutes

Running and verifying the sanitized database container

After building the image, run the container and connect to it to verify that all data has been correctly anonymized, sanitized, and is ready for development.

#9about 2 minutes

Features and limitations of SQL Server on Linux

SQL Server on Linux supports core database engine features like SQL CLR, but lacks Windows-dependent components like Reporting and Analysis Services.

Related jobs
Jobs that call for the skills explored in this talk.

Matching moments

Organizing a developer conference for 15,000 attendees
01:32 MIN

Organizing a developer conference for 15,000 attendees

Cat Herding with Lions and Tigers - Christian Heilmann

Increasing the value of talk recordings post-event
04:57 MIN

Increasing the value of talk recordings post-event

Cat Herding with Lions and Tigers - Christian Heilmann

Establishing a single source of truth for all data
02:39 MIN

Establishing a single source of truth for all data

Cat Herding with Lions and Tigers - Christian Heilmann

Automating video post-production with local scripts
02:54 MIN

Automating video post-production with local scripts

Cat Herding with Lions and Tigers - Christian Heilmann

Using content channels to build an event community
04:49 MIN

Using content channels to build an event community

Cat Herding with Lions and Tigers - Christian Heilmann

Why corporate AI adoption lags behind the hype
03:28 MIN

Why corporate AI adoption lags behind the hype

What 2025 Taught Us: A Year-End Special with Hung Lee

Breaking down silos between HR, tech, and business
03:39 MIN

Breaking down silos between HR, tech, and business

What 2025 Taught Us: A Year-End Special with Hung Lee

Moving beyond headcount to solve business problems
04:27 MIN

Moving beyond headcount to solve business problems

What 2025 Taught Us: A Year-End Special with Hung Lee

Featured Partners

Related Videos

See all videos
Databases on Kubernetes48:45

Databases on Kubernetes

Denis Souza Rosa

Databases on Kubernetes: Why you should care45:49

Databases on Kubernetes: Why you should care

Denis Wilson Souza Rosa & Steffen Schneider

Automated MS SQL Server database deployments with dacpacs and Azure DevOps39:35

Automated MS SQL Server database deployments with dacpacs and Azure DevOps

Sebastian Wolff

Demystifying DevOps—Pros, cons, dos & don'ts51:13

Demystifying DevOps—Pros, cons, dos & don'ts

Thomas Fuchs, Waleed Arshad & Frank Dornberger & Idir Ouhab Meskine:

Reusing apps between teams and environments through Containers43:39

Reusing apps between teams and environments through Containers

Adrian Kosmaczewski

Compose the Future: Building Agentic Applications, Made Simple with Docker50:09

Compose the Future: Building Agentic Applications, Made Simple with Docker

Mark Cavage, Tushar Jain, Jim Clark & Yunong Xiao

Python-Based Data Streaming Pipelines Within Minutes39:04

Python-Based Data Streaming Pipelines Within Minutes

Bobur Umurzokov

Integrating backups into your GitOps Pipeline25:24

Integrating backups into your GitOps Pipeline

Florian Trieloff

Related Articles

View all articles
AG
Andre Braun, GitLab
Now is the time for industrialized software development
Now is the time for industrialized software development Recently, I received a letter from my car’s manufacturer alerting me to a recall. They had discovered a defective part and wanted to replace it. It was easily fixed, and I might have forgotten a...
Now is the time for industrialized software development

From learning to earning

Jobs that call for the skills explored in this talk.

DevOps

DevOps

UnderDefense

Remote
Bash
Azure
React
Kafka
+16