DevOps in the Spotlight, Foundational Sessions

W04 Database DevOps with SQL Server


8:00am - 9:15am

Level: Intermediate to Advanced

Brian A. Randell

Staff Developer Advocate


Delivering value to your customers requires you providing a quality experience. A quality experience where your app is intuitive, available, fast, and connected. And for many apps, the foundation of that whole experience is a SQL Server database.

In this fast-changing world, 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 DevOps plan for your database.

In this session, you'll learn where the SQL Server database fits in to DevOps, and how you can use tools and processes to extend your infrastructure to make the database a first-class citizen, 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 like development, test, user acceptance training (UAT) and production. You’ll see how you can update a live database while it’s being used and learn how to move your apps forward so you can provide a quality experience for your users.

We’ll look at SQL Server Data Tools, EF Core Migrations, and tooling from Redgate.

You will learn:

  • Why you need DevOps for your database
  • How to use Microsoft and Redgate tools to implement a good database DevOps process
  • How to make updates to a live system while it’s being used