Getting release management right for SQL Server

This isn’t the dark ages any more.

You’ve learned that you need to put your database in source control and you’ve hopefully set up some sort of automated build and regression testing process.

However, your deployments are still expensive and risky. You find it hard to keep track of what has been deployed to each environment. You don’t have a great deal of confidence that the production database is still in line with source control. You may have heard of the automated deployment functionality in VSTS or Octopus Deploy but you haven’t tried it yet… at least not for SQL Server.

In this session I’ll automate a deployment pipeline in a couple of different ways.

I’ll discuss the importance of your database model as well as repeatable upgrade scripts and discuss the pros and cons of different approaches to automation. I’ll also discuss how to monitor for and protect yourself from database drift.

By the end you will have a better idea about which strategy will suit your databases.

Event Timeslots (1)

Track 3
-
Alex Yates

Leave a Reply