Belfast SQL Server User Group

Welcome to the Belfast Chapter

Next Meeting




The elephant in the room: Continuous Delivery for Databases

  • In-Person @ Adelaide Exchange Belfast, Antrim, United Kingdom (map)
  • 18:00 - 20:00 GMT Daylight Time
  • Language: English

The presentation will cover the following.

6:00 - 6:15: Registration & Intro
6:15 - 7:00: The elephant in the room: Continuous Delivery for Databases - Part 1.
7:00 - 7:15: Break and Refreshments
7:15 - 8:00: The elephant in the room: Continuous Delivery for Databases - Part 2.



Details for slides can be found

Featured Presentation:

The elephant in the room: Continuous Delivery for Databases

Alex Yates, Director DLM Consultants

(including a step by step walkthrough of setting up automated builds with Redgate tools and TeamCity) Let’s talk about constraints. What’s holding you back from achieving Continuous Delivery? Relational databases. If it’s painful, do it often… Your app is automatically integrated, tested and packaged for deployment in minutes. But what about the database? Of course, the database brings with it its own complications and risks. We’ll talk about both the human and technical changes which are necessary to achieve a reliable, nimble, and automatable database deployment process. You’ll learn how to bring Dev and Ops closer together as well as customize established practices and existing toolsets to build a database deployment pipeline and speed up delivery while at the same time protecting the data (and your sanity). In particular, we’ll look at two alternative solutions to the problem and their relative pros and cons. Declarative/state based development vs purely migrations driven development. Once we have examined the relative strengths of the two approaches we’ll take a practical look at how to configure automated database builds using TeamCity and Redgate tools. This small step will help us to achieve continuous integration and lay fertile foundations for continuous delivery. By the end of the session, delegates will have learned not only that this elephant in the room can be tamed, but they will have an idea about which strategy is right for them.

About Alex:
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins. A keen community member, he co-organises SQL Relay, is the founder of and has been recognised as a Microsoft Data Platform MVP since 2017.


Broadtree Solutions

Ormo Baths



Back to Top