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

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

Republish: Release Wednesday

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

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

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

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

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

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?

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