Data and Analytics, Microsoft Sessions, Cutting-Edge AI

W20 SQL Projects in SSMS and Visual Studio

07/29/2026

1:30pm - 2:45pm

Drew Skwiers-Koballa

Principal Program Manager

Microsoft

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.