My References: Getting CI right for SQL Server


This isn’t the dark ages any more. You’ve learned that you need to put your database in source control and you’re competent with source control systems like TFS or Git. You’ve also learned how to express your database in script form using a tool like SSDT, Flyway or Redgate.

However, you haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins. You still haven’t written as many automated tests as you know you should. Even if you have you aren’t sure how the process should work for SQL Server builds and tests.

In this session I’ll talk through the two most common ways to automate your database builds/deploys and the pros and cons of each. Then I’ll show you how to use tSQLt to build a suite of tests that can be run as part of your build process, giving you confidence in the quality of your code.



Other talks I’ve delivered

Support implementing database CI

If you are looking for database CI training or consultancy DLM Consultants can help. We offer on-site consultancy as well as online workshops. Our full public workshops schedule is here.

To read more about our services or to contact us head to