If deploying database changes still feels like a bottleneck in your DevOps pipeline, it’s time to meet the next generation of SQL Projects. In this session, Brian will show how new features in SQL Server Data Tools (SSDT) are making it easier to do Database DevOps right on Windows, macOS or Linux. You’ll learn how treating your database schema “as code” can bring the same agility and reliability to database changes as you expect from application code.

Brian will explore the new SDK-style SQL project format and other enhancements that make database versioning and automation easier than ever. See how you can use Visual Studio Code’s integrated SQL projects and Visual Studio’s improved SSDT tooling to let you develop where you want with unified project files. Through demos, we’ll walk through setting up source control for your database, running build and schema validation in CI, and generating deployment scripts for safe, repeatable releases. By the end, you’ll be ready to bring your databases into the DevOps era with confidence.

You will learn:

• What the “next-gen” SQL project tooling is (using Microsoft’s new SDK-style SQL projects) and how it differs from traditional database projects.
• How to use Visual Studio 2022 SSDT and Visual Studio Code to version-control your database schema, run CI builds, and catch issues with automated tests or code analysis.
• Best practices for CI/CD of database changes – including generating deployment scripts (DACPACs), using pipelines (GitHub Actions/Azure DevOps) to deploy updates, and avoiding drift between environments.