Modernizing Local Development: Using SDK-Style Projects with Docker
Proposed session for SQLBits 2026TL; 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.
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
Speakers
Malcolm Smith's other proposed sessions for 2026
Personal Growth To Professional Success: The Power of Training & Community in Your Life Journey - 2026
Unit Testing & Code Style: Enhancing Database Code Quality with SQLCop and tSQLt - 2026