Modern Software Engineering

TH10 DevOps for the SQL Server Database


11:00am - 12:15pm

Level: Introductory to Intermediate

Brian A. Randell

Staff Developer Advocate


DevOps is still the answer and you need to have the database properly in the mix. How do you manage the necessary changes needed to support your applications? How do you track these changes and follow a change from development to test to production? You need an effective database lifecycle management plan.

In this session, you'll learn where SQL Server fits in to a good DevOps-enabled process and how you can use tools to extend your infrastructure to make the database a first-class citizen in your development team’s day-to-day, just like your source code. You'll see how to track changes with version control; create update packages; and deploy to multiple environments with complete automation to environments like development, test, UAT, and production. You'll learn the process as well as see examples using the Visual Studio SQL Server Database Tools and commercial tools from Redgate for that inner developer loop. Looking at the outer team development loop, we’ll look at how you do CI/CD with GitHub Actions or Azure Pipelines, and talk about the various deployment targets: self-hosted, PaaS in the cloud, and containerization.

You will learn:

  • Why you need DevOps for your database
  • How to define good developer hygiene around database changes
  • How to use Microsoft, GitHub, and Redgate tools to implement the DevOps process