Tag Archives: deployment

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

Mission Critical Deployments

Posted on August 17, 2015 by

Talk about a lot of pressure to get a software deployment correct. A software install on an Airbus airplane resulted in a file containing parameters being wiped. This error caused (apparently) an airplane to crash when three engines cut off in … Continue reading →

Posted in Editorial | Tagged ,

Monitoring After Deployment

Posted on April 17, 2015 by

Deployments of database and application changes have tended to be stressful in my career. I’ve seen the actual deployment of changes fail, installation programs crash, the startup of an application error out, or the famous blue screen of death from … Continue reading →

Posted in Editorial | Tagged ,

State v Migrations

Posted on April 9, 2015 by

Most people work in evolutionary databases. By that I mean a database where you have some schema, and over time you are altering that schema. You might be adding columns to tables or views, changing stored procedure or function code, … Continue reading →

Posted in Editorial | Tagged ,

No State Based Deployments

Posted on March 2, 2015 by

I’ve been studying deployment ideas and technologies for quite some time now, but it’s been a focus for the last year or two as my employer is interested in this area. I’ve been reading books and talking to people, comparing … Continue reading →

Posted in Editorial | Tagged , , , ,