Database and Analytics

W01 Database Lifecycle Management and the SQL Server Database


8:00am - 9:15am

Level: Intermediate

Brian Randell

Brian Randell


MCW Technologies

DevOps is hot, but all too often the database is the missing link. How do you manage the necessary changes need 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 the SQL Server database fits in to DevOps, and how you can use tools 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 with complete automation, deploy to multiple environments like development, test, UAT, and production, and basically bring things under control with Database Lifecycle Management. To do all this, you'll learn the process as well as see examples using the Visual Studio SQL Server Database Tools, Team Foundation Server Team Build, Release Management, as well as custom tools from Redgate.

You will learn:

  • Why you need DevOps for your database
  • How to define a good Database Lifecycle Management (DLM) process
  • How to use Microsoft and Redgate tools to implement the DLM process