Video: Fundamentals of CI/CD for SQL projects

In a July 2026 episode of Data Exposed, I discussed the setup of Azure DevOps pipelines for SQL database CI/CD backed by SQL projects. Learn how to keep your database protected by firewall rules, leverage passwordless authentication, and create a strong foundation of database CI/CD pipelines.

Building automated pipelines with your SQL database projects enables you to build a rich CI/CD ecosystem to ensure that your application is being deployed with good quality code and at high confidence of success. SQL Database Projects are compatible with just about every automation environment because fundamentally they’re built on top of the .NET SDK, a free and cross-platform development platform. You can develop the Microsoft.Build.Sql projects in VS Code and SQL Server Management Studio (SSMS).