Tag Archives: deployment

Rolling Back Migrations

Posted on October 24, 2018 by

I happen to be a fan of database migrations as a way of making and deploying database changes. This is an approach that tracks each of the scripts run by developers in their working environments and the replays these scripts … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Are Indexes Actually Changes to the System?

Posted on October 2, 2018 by

I haven’t thought about this in some time, but Brent Ozar raises an interesting question: should index changes require change control? I’ve worked in an organization that didn’t consider an index change to be an item that was presented as an … Continue reading →

Posted in Editorial | Tagged ,

Dark Reads During a Migration

Posted on September 17, 2018 by

I caught a post from the Slack Engineering team titled: Re-architecting Slack’s Workspace Preferences: How to Move to an EAV Model to Support Scalability. In the post, an engineering intern describes the move from a blob table (actually a table storing … Continue reading →

Posted in Editorial | Tagged

Republish: Release Wednesday

Posted on June 20, 2018 by

In the UK getting ready for SQL in the City, so Release Wednesday being republished.

Posted in Editorial | Tagged