Next-gen SQL Projects with Microsoft.Build.Sql

With Microsoft.Build.Sql SDK-style SQL projects, your database objects are stored as code for streamlined development and source control. Integrated SQL code analysis and dynamically generated deployment plans through tools like SqlPackage CLI enable reliable and trustworthy updates whether you’re managing a single database or an entire fleet. When your SQL database is deployed to Fabric, source control integration is part of the database platform. In this session we’ll learn how to develop and deploy your database alongside your app components with SQL projects from the IDE to CI/CD in SQL Server, Azure SQL, and SQL database in Fabric. Armed with examples for Azure DevOps and GitHub Actions, you’ll be ready to automate steps in your development process and streamline database changes.

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