Database DevOps – a crash course!

Deploying database changes, for many of us, is horrible. It’s often a manual, time-consuming and error-prone process. When it goes wrong, and it often does, the consequences can be serious. The DevOps, Continuous Delivery and Application Lifecycle Management (ALM) movements have revolutionised our ability to deliver software regularly and reliably. Unfortunately, many of us have not adopted the associated practices for our databases. There are, however, tools and techniques (technical and cultural) to implement Database DevOps/Database Lifecycle Management (DLM), allowing us to manage SQL changes efficiently and safely.

Who is this course for?

DevOps is about bringing dev and ops folk closer together, so this course is relevant whether you are a developer, a DBA or anyone else who plays a role in writing, testing or deploying SQL Server schema and data changes.

Course content

Introduction to Database DevOps/DLM and an overview of the different tools that are available

Discussion about the different approaches: model vs migration / shared dev DB vs dedicated dev DBs

HANDS-ON LAB: Source control a database using Git, VSTS/TFS and Redgate SQL Change Automation (formerly called ReadyRoll)

HANDS-ON LAB: Working with static data

Introduction to continuous integration

HANDS-ON LAB: Automating builds with VSTS/TFS and Redgate SQL Change Automation

Introduction to continuous integration

HANDS-ON LAB: Continuous delivery to an integration database

HANDS-ON LAB: Production-ready automated releases (automation while keeping DBAs happy)