Author Archive for Alex Yates

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…

Human-go-previous

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…

tsql2sday-300x300

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.…

lc24

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…

groupby_logo-350x350

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…

avatar

DLM Digest issue 1 – Virtualisation

We’ve just released the inaugural Database Lifecycle Management (DLM) Digest, a monthly report of the latest developments in the world of database DevOps. You can read the full digest here. You can subscribe to future digests here. Just one email per month to keep your knowledge about all things DLM up to date. Here’s this month’s note from the editor:…