Your database deployments are still stuck in the proverbial dark ages! You might have build scripts for your database in source control, but deploying is still an exercise in creating the perfect script, and don't even think about making a data (or data type) change! Learn how to leverage Continuous Integration and Continuous Deployment practices to accelerate feature deployment and catch regression issues up front! In this talk, we will learn techniques to utilize SQL Server Data Tools, tSQLt, Azure DevOps, and Docker for automating your database testing and deployments. We will also learn techniques for deploying database changes to development, QA, and (gasp) production, fully integrating your database into your existing DevOps pipeline. Finally, there will be a review of potential pitfalls and where you may want to fall back to old reliable: the hand-built script.

The video is not available to view online.