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 , | Leave a comment

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 | Leave a comment

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

Shipping Database Changes–T-SQL Tuesday #90

Posted on May 9, 2017 by

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 , , ,

Making VSTS Deployment Changes to Databases without Breaking Your Application

Posted on April 17, 2017 by

One of the things that I do a lot is demo changes to databases with CI/CD in a DevOps fashion. However, I also want to make some application changes to my sample app without breaking things. As a result, I’ve … Continue reading →

Posted in Blog | Tagged , , , ,

Upgrading VSTS Redgate Build Tasks

Posted on April 11, 2017 by

I’ve been putting it off, but in prepping for SQL Bits demos, I decided this was a good time to just upgrade my original build and release tasks on VSTS from v1 to v2 for the Redgate tasks. The first … Continue reading →

Posted in Blog | Tagged , , ,

Staging Deployments

Posted on April 7, 2017 by

This editorial was originally published on Nov 30, 2011. It is being republished as Steve is out of the office. Software development can be a complicated dance. Most of us do not work for a software vendor and don’t have … Continue reading →

Posted in Editorial | Tagged ,

Watch the Manual DBA v Automated Deployment Challenge

Posted on January 5, 2017 by

At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those from development to test, staging, and production environments. Actually, I don’t think we went to production because I didn’t have … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

What’s Your Smoke Test?

Posted on August 19, 2016 by

Many DBAs and operational staff regularly stress over software deployments to production systems. Even when the administrator has built and tested the deployment scripts, there is still a nagging fear that something will be missed, incurring downtime for systems. I … Continue reading →

Posted in Editorial | Tagged , ,