Tag Archives: deployment

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 , | Comments Off on Are Indexes Actually Changes to the System?

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 | Comments Off on Dark Reads During a Migration

Republish: Release Wednesday

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

Posted in Editorial | Tagged | Comments Off on Republish: Release Wednesday

Shipping Database Changes–T-SQL Tuesday #90

This is a good T-SQL Tuesday topic from James Anderson: shipping database changes. It’s especially poignant for me since I talk and present often on this topic. Much of my work at Redgate involves helping people implement DevOps for Databases, … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Shipping Database Changes–T-SQL Tuesday #90