Your database objects are stored as code for development in Visual Studio or VS Code with Microsoft.Build.Sql SDK-style SQL projects, but the advantages don’t stop there. SQL code analysis and other build-time tests can validate database code quality and correctness during continuous integration of code changes. With SQL projects delivering database object updates is easier and more reliable whether you're managing one database or a fleet of databases because the deployment plan is dynamically calculated through the SqlPackage CLI. 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. Armed with examples for Azure DevOps and GitHub Actions, you’ll be ready to automate steps in your development process and leverage the latest of the new SQL projects to 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