DevOps, CI, CD, ALM… for databases

DevOps, continuous delivery, ALM. Pick your paradigm, the fundamentals are the same, and the database is often ignored. It is ignored despite the fact that it is often the component with the most scope for improvement. It's time we fixed that. The database should not be a bottleneck on delivering customer value.

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…

Iceland - square

My SMART objectives for 2018

Two years ago I wrote about why new year’s resolutions suck and why set myself some SMART objectives for 2016 instead. SMART objectives have the following five attributes: S pecifc M easurable A ttainable R ealistic T ime-related I’ve used SMART objectives in business because they are good for motivation and accountability. Most new year’s resolutions are broken because they fail to possess some of these attributes.…


DevOps, Culture and Trust

The slide above is from my DevOps 101 session. Sometimes people need reminding. DevOps is about five things: C – ulture a – utomation l – ean m – etrics s – haring First, and with a capital letter, comes Culture. Let’s talk about why. Dysfunctional teams As a consultant, the engagements I find frustrating are where a customer asks…


Doing the right thing

I enjoyed solving problems and helping people achieve great things. I got a lot of scope to achieve this in my role because our software was pretty awesome – but at the end of the day the measure of my success was how many licences I could help to sell. I wanted the measure of my success to be how…


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…


Rolling back database changes

@_AlexYates_ Hi, Could you give insight how rollback work with Database CI/CD? — Gourav Sharma (@sharmagourav) October 30, 2017 A thorny topic. Rolling back code is easy. Normally you can just redeploy the old binaries and you’re done. Databases are more difficult – because data. The existence of persistent data has two significant consequences: You can’t just redeploy the entire…