Tag Archives: deployment

Rolling Back Migrations

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?

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

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

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

Posted in Editorial | Tagged