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…

Developing databases: shared vs dedicated?
If your dev team builds C# projects, each developer will be compiling their code locally to test it out before committing any changes to source control. Then the version of the source code that exists in source control will be used whenever the code is deployed to live. This means there is a single source of truth and a complete…

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…

Managing Artifacts with the Redgate Create Release step template from the Octopus Deploy Library
When I quit my job at Redgate to be a consultant I thought I’d have more time to blog. Boy was that naive! It turns out running your own company is a bit of a time sink. Anyway, I thought it was about time I wrote a proper technical blog post. But I’ll keep it quick. I’ve got to get…

T-SQL Tuesday #90 – You are doing “Continuous Integration” wrong!
It’s still Tuesday alright… In the USA anyway. (And by the USA I mean Hawaii.) This blog post is part of T-SQL Tuesday #90 – Shipping Database Changes, hosted by James Anderson. 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.…

DLM Consultants are partnering with Octopus Deploy
I’ve been a fan of Octopus Deploy for a while. (Even when it was one of my direct competitors if I’m honest!) And now I’m proud to announce that DLM Consultants will become an official Octopus Deploy partner! What I want from my partnerships Now this has forced me to think a little more carefully about what I want from…

My SMART objectives for 2017
Last year I wrote about why new year’s resolutions suck and why I’ll be setting 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…

Filling big boots: I’m joining the SQL Relay team
SQL Relay means a lot to me. At SQL Bits in 2014 I was talking with Steph Locke about how I had just delivered my first technical session at a user group. She told me that I should start submitting to bigger conferences. I was nervous. I was just a sales guy from Redgate. What would experienced DBAs and developers…

GroupBy conference by Brent Ozar
I love when people challenge the status quo – and Brent has done just that with his new event: GroupBy I wrote last month about the challenges of continuing to fund free training events. Many of us love these free events but venues and travel and catering is expensive. One approach that a few people have taken is to move to…