SQL Server - Code Aperture

Branching with Redgate SQL Source Control

A couple of years ago my team and I decided to change the name of a column in a loan origination system. 99% of the time this was no big deal. However, this was the primary key identity column used to uniquely identify a loan in the application. Renaming a

Automation

Database Changes - Build Once, Deploy Anywhere

A core concept of continuous delivery is build once, deploy anywhere. The idea behind it is simple, the code is built once and deployed to all the servers throughout the various environments. For example, if you had a development, testing, staging and production server, you would build once before deploying

Automation

How to bring down a Production SQL Server with one line of code

Small releases shouldn't cause major outages. It certainly shouldn't take down a production database server. In the end it was one line of code. That exposed several flaws and brought down the database server. Wednesday night my team and I deployed a release to production. The release consisted of both