Tag Archives: deployment

Practice Those Scripts

Posted on June 21, 2019 by way0utwest

I’ve written lots of scripts that were deployed to production. I’ve often had another set of eyes look them over, and still, we made mistakes. In fact, a recent Salesforce outage was blamed on a poorly written database script that … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Practice Those Scripts

Rolling Back Migrations

Posted on October 24, 2018 by way0utwest

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 , | Comments Off on Rolling Back Migrations

Are Indexes Actually Changes to the System?

Posted on October 2, 2018 by way0utwest

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

Posted on September 17, 2018 by way0utwest

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