Uncategorized

Mission

A new chapter

I wasn’t kidding when I tweeted this a few days ago: Yesterday marked three years since my life changing decision to start DLM Consultants. It’s been a good three years. And I suspect the next three years will be even better. https://t.co/TYyz8lXvox — Alex Yates (@_AlexYates_) May 10, 2019 Every syllable of that tweet had been considered very carefully. The…

Code

How to call the Azure DevOps Services API with PowerShell on hosted build agents

The problem My customer has a data warehouse solution. It consists of nine databases with a well defined architecture. They need to be deployed in a specific order – the source database first, followed by various dependant databases in sequence. Due to the tight coupling of the databases, they all exist in the same git repo in Azure DevOps Services, with…

DLMWorkshopsReviews-ZoomedIn

Feedback on the new DLM Workshops

Just a quick note to share my excitement about how well the first iteration of our new and improved DLM Workshops went! The first workshop ran on UK hours earlier this month. It was the first time we hosted the VMs ourselves and the first time we ran a public course using TFS/VSTS and it went really well. We now…

2017-10-11 15.29.38-2-small-widescreen

Speaking Mentors

I’m one of the organisers of SQL Relay and I’m always looking for new speakers. There aren’t enough new people speaking at community events and that’s sad. It doesn’t promote fresh ideas and thinking. On Wednesday evening last week I was thinking about this and I was feeling generous so I casually made an offer on Twitter as I left…

tsql2sday-300x300

Three People Who Made a Difference

This blog post is part of T-SQL Tuesday #96 – Three People Who Made a Difference, hosted by Ewald Cress. T-SQL Tuesday is an online blog party started by Adam Mechanic and you are invited to join in. A record of every previous T-SQL Tuesday is maintained by Steve Jones. Chris O’Dell (book|t) My very first speaking experience was a bit of…

Hippos square

Critiquing two different approaches to delivering databases: Migrations vs state

tl;dr Some argue that thinking about databases purely in terms of migrations provides repeatability and reliable deployments. Others argue that working declaratively, treating the database state as code, is a better development experience providing immutability, reliable testing and greater productivity. Most people have a strong opinion – not enough people discuss the relative pros and cons in a balanced way.…