What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps, and other weird buzzwords, we the DBAs gotta learn to keep up. It’s time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we’re getting into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.

In this session, the first of a multi-part series, we will learn what is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.

Meet SSDT (SQL Server Data Tools) that comes with the SQL Database Project as an effective tool for integrating database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.

But before we can dive into SSDT, we must all be on the same page and understand the terms and methodologies used in the world of software development lifecycles. After all, with the power of SSDT, we the DBAs also become a part of this world!


Eitan Blumin is a Microsoft Data Platform MVP with decades of experience in all fields relating to Microsoft SQL Server databases and the Microsoft Data Platform.

Eitan Blumin is currently working as a Senior SQL Server Consultant, Solutions Architect, and DBA Team Leader at Madeira Data Solutions, the leading Microsoft Data Platform consulting company in Israel. Other than his day-to-day consultant work, he also co-hosts the popular “SQL Server Radio” podcast with Guy Glantser, writes professional materials for the SQL Server community, delivers professional presentations and courses, and serves as a pivotal source of expert knowledge for the Madeira team.