Welcome to the Belfast Chapter

Next Meeting

Thursday,

June

25

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.


URL: https://www.eventbrite.co.uk/e/belfast-sql-server-usergroup-tickets-17352556965

 

Details for slides can be found http://workingwithdevs.com/delivering-databases-migrations-vs-state/

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 is a Data Platform MVP who loves DevOps. Alex has been helping data professionals 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 helps organise the London Continuous Delivery meetup and SQL Relay. He blogs at workingwithdevs.com, speaks wherever they'll let him and manages the DLM Digest monthly email: a report on the latest database DevOps news/tutorials. He's quite fond of nutella. And otters. (Not together