CI and CD with SSDT and Living to Tell about It

Target Audience:

Application DBA, SQL, DevOps


Until a few years ago, it was common to have the database development lifecycle completely separate from the main application development lifecycle. While the app dev team enjoyed modern lifecycle techniques, the DBAs find themselves inventing their own solutions for things that already come pre-packaged and ready-to-use for the application developers next door. Source control? Let’s use a file server or the DBA’s PC. Version history? Maybe in my Dropbox somewhere. Unit tests? Not in our domain. Continuous integration/deployment? Never heard of it.

As a result, both DBA and app dev teams find themselves fighting to “align” between database schemas and application versions. In the end, we are left with poor communication between the application and database teams, longer development cycles, longer or even non-existent testing cycles, many errors during deployment (most of which are sometimes quite embarrassing, other times downright dangerous), and more.

Meet SSDT (SQL Server Data Tools), that comes with the SQL Server Database Project as an answer to all of the problems above. In this session, I will be presenting the methodology behind SSDT, the various SSDT tooling that we get for implementing that methodology, how to solve common issues and edge cases, and we will also learn important lessons in source control, Git flows, and CI/CD pipelines.

Why I Want to Present This Session:

This webinar is based on my real-world experience of implementing source control methodologies and CI/CD for SQL Server database, using the Microsoft SSDT environment. My experience comes with answers for all the common fears and objections coming from naysayers, for common problems while starting with SSDT for the first time, and for various problematic edge cases.

If you ask me, every self-respecting SQL Server DBA must be familiar with this tool and its methodologies, and why it can be beneficial for every organization. We all know the database is a critical element of your software product. It’s high time for that fact to be reflected in your database development lifecycle!

Additional Resources:

The following two tabs change content below.
Eitan Blumin is a SQL Server Database Expert with more than 13 years of experience in all fields relating to Microsoft SQL Server databases (since the year 2005), including but not limited to: Database design, management, TSQL programming, performance tuning, replication, backup management, security management, high availability and disaster recovery, SSIS, SSRS, encryption and more. Eitan has a deep understanding of SQL Server fundamentals and architecture and is able to craft creative solutions for virtually any problem. Eitan Blumin also has 10 years of experience in Classic ASP, HTML and CSS web development (2000-2010), and some experience in a wide variety of development environments such as PHP, C, C++, C#, VB, Java, Perl, Assembler, Powershell and more. Eitan Blumin is currently working as a senior SQL Server Consultant and Managed Services Team Leader at Madeira Data Solutions. Other than his day-to-day consultant work, he also 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.

Latest posts by Eitan Blumin (see all)

, , , , , , ,
Previous Post
Dynamic Search Queries and How to Protect Them
Next Post
Eight hours of work in 20 minutes – partitioning rocks

2 Comments. Leave new

Eugene Meidinger
September 14, 2019 9:01 am

I think this is a relevant and interesting topic. I truly believe that CI/CD is uniquely challenging when it comes to databases.

I would consider splitting this abstract up into 2-3 paragraphs to improve readability. I would also expand upon what you will cover. You do a GREAT job of painting the pain points that CI/CD solves, but then spends a single sentence on the specifics of the session. Some audience members might be skeptical that SSDT can solve communications problems, etc. It would also be interesting to know if you are just covering the tooling or if you’ll be covering some of the soft skill pieces you imply.

Overall, a really interesting session!


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.