22-25 April 2026

Modernizing Local Development: Using SDK-Style Projects with Docker

Proposed session for SQLBits 2026

TL; DR

A guide to updating from a local SQL Server install to Docker for your local development. With a focus on alignment with CI/CD processes and resources, to reduce 'it works on my machine' issues This will cover the basics of Docker and the SDK Style Database projects, touching on the use of database testing.

Session Details

We've all experienced the challenges of local development environments, setting up virtual machines or complex configurations, which can be time-consuming and error prone.
In this session, we will explore how to use Docker (SQL on Linux) to build SDK-style projects that are easy to set up and match CI/CD pipelines.

Starting with the basics of Docker, basic management of Docker containers, and interacting with them. Expanding to building a local development environment using Docker Compose, a powerful tool for orchestrating multi-container applications.

Next, we will explore developing SDK Style Database Project. We'll also discuss how to use Docker to create reproducible development environments that can be easily shared.

Throughout the session, I'll provide examples and code snippets to help you get started. By the end of the session, you'll have a solid understanding of how to use these technologies to build powerful local development environments for your data projects. Whether you're a beginner or an experienced data professional, this session will provide valuable insights and practical tips for improving your development workflow.

3 things you'll get out of this session

Optimization of local development in line with CI/CD processes. A guide for non-docker users on how they can use Docker How SDK Style Projects can be layered