Deployments aren't enough—your database deserves a real development process. In this session, we'll explore the components of a modern database development cycle using Microsoft.Build.Sql SDK-style SQL projects in Visual Studio and SSMS, integrated with GitHub and Azure DevOps. Too often, database-as-code stops at deploying changes, missing the opportunity to catch problems early. A complete development workflow brings code analysis to surface antipatterns before they ship, deployment "practice runs" to validate changes against production schemas, and unit tests to build confidence in mature databases. We'll demonstrate how SQL projects store your database objects as code, enable build-time validation during CI, and generate dynamic deployment plans through the SqlPackage CLI. Whether you're writing T-SQL directly or your data layer is managed by an ORM like EF Core, you'll leave with examples for Azure DevOps and GitHub Actions ready to automate your database development process.

You will learn:

• How to develop and deploy your database alongside your app components
• How to automate database deployment steps across multiple environments
• How to improve database code quality with CI checks