SQLBits 2023

Applying effective Source Control to your Database System

How can you everage SSDT in order to deploy DB changes as part of your CI/CD pipeline
When it comes to building applications we all know how to manage our code. We make branches, apply changes , merge them and carry on. But what about databases? Do you often find that this part of the project is difficult to integrate within your pipeline?

What if I told you that there is a way to deploy your database as part of your full DevOps pipeline, and apply the same principles to your database code as you would to your application code. That is where SQL Server Data Tools (SSDT) comes in, and maybe even become your best friend.

In this session, I will take you through a journey showing you how you can leverage SSDT in order to simplify your database development process and deploy the changes you need to the environment of your choice and spend less time pulling your hair out and more time doing what you need to do: application and/or database development.