Hi, my name is Sjors Takes. I work for Albumprinter, a company located in the Netherlands, where I started in March, 2014 as a SQL Server DBA. Before, I worked as a production SQL Server DBA for a hosting company where I managed over 50 SQL Server instances with more than 900 databases. I changed jobs because I wanted to do more development work. I did not expect the adventure I am in right now.
How it all started
June 2014. As a good DBA, I keep my knowledge up to date by reading several SQL related newsletters. So I became aware of the existence of a book called The Phoenix Project. I immediately ordered it and started reading. After I finished reading it, I knew we had to work differently at our company. Luckily we got a new CTO with the same ideas and he was already reorganizing the IT departments based on LEAN principles.
July, 2014. Reading more and more about Continuous Delivery, Continuous Deployment and Continuous Integration I came to realize that we had to source control our databases. Luckily again, our lead .NET developer came by my desk asking if we could use Redgate’s SQL Source Control. Yes, of course! 🙂
There happened to be a SQL in the City workshop called ‘Continuous Integration for SQL Server Stairway’ with the aim to teach how to link a source control repository to a build system using Redgate’s Automation Pack. At that time working with source control repositories and build servers was (almost) completely new to me. I just worked a few months for my current company and during those first few months my primary concerns were taking care database management was set up.
To increase my knowledge about version control and Continuous Integration for databases, I’ve read almost everything from the Database Lifecycle Management series on Simple Talk when I was commuting. During working hours, I began to set up a proof of concept with the Bookstore database from the SQL Source Control Basics book. And from that moment on I was building a database deployment pipeline.
December, 2014. I decided to blog about my experiences.
In the posts to come, I am going to write about source controlling databases, Continuous Integration, how I set things up, what problems I had to deal with and what I’ve learned along the way. As the database deployment pipeline evolves to enable Continuous Delivery and maybe even Continuous Deployment, I am going to write about those concepts as well. All under the umbrella that is Database Lifecycle Management (DLM). Hope you enjoy!
I’ve been talking to the folks at Redgate as I write these posts. They haven’t paid me to say anything, and my company paid THEM for the tools we’re using. I’m purely documenting my experiences building a database deployment pipeline.