a fly on the wall view of some key problems with delivering software and databases

Most blogs about software delivery are written by software developers or 'DevOps' types. This is logical, but sometimes it helps to take a step back. This blog is from the perspective of someone who is not a developer, but who works with many of them at a variety of organisations. From this perspective some patterns jump out, even to the untrained eye. Sometimes the solutions are obvious, if only it was possible to look at them from a different angle.

Jenkins

How to change the default port in Jenkins

tl;dr Go to C:\Program Files (x86)\Jenkins (I’m using Windows Server 2012 and assuming it’s installed to default location) Open Jenkins.xml Edit the –httpPort argument Restart the Jenkins service Now Jenkins will permanently use the new port There are various other solutions via the command prompt but this one just seems so much simpler and based on various other posts Jenkins seems…

mig v2 (square)

Deploying databases using Red Gate’s ‘Migrations v2′ functionality

tl;dr: A solution to deploying database changes that diff tools cannot handle Migrations v2 offers a way to deploy complex changes (e.g. table renames, new NOT NULL columns and data migrations) using Red Gate SQL Compare by allowing the user to add custom scripts, using Red Gate SQL Source Control when needed. These custom deployment scripts are combined with SQL Compare generated…

William_Shakespeare_portrait_section

If Shakespeare had invented DevOps

About a month ago a couple of my colleagues, James Murtagh (twitter) and Becky Amos (twitter), challenged me to write an alternative version of the prologue to Romeo and Juliet. Here is what I came up with. Comments welcome, but only if they are in iambic pentameter. *** Two households, both alike in dignity, In the IT dept, where we…

TechCoffeeIcon

Tech coffee: A successful protocol for data transfer between human brains

This week Sean Newham (@SeanNewham) and I are visiting a company called Farm Credit Services of America. Last night a bunch of them, including John Morehouse (@SqlrUs), their production DBA, took us out to dinner and we were discussing how DBAs and developers should be better at working together. They play different but important roles and both are necessary in…

WP_20140923_16_05_34_Pro

Using Entity Framework (or some other ORM tool)? Having performance issues? Here’s a solution.

This week I’m a booth babe for Red Gate at BASTA, a conference for Microsoft stack developers in Germany. This year the theme is ALM (Application Lifecycle Management). With so many people talking about how they deliver their updates I thought that discussions about our SQL Server version control, CI and release management plug-ins would be the topic of the…

AgileOTB

Liveblogging from Agile on the Beach

Please excuse typo’s, grammatical errors, poor style/structure and general rough-ness. I’m continuously deploying my updates to live whilst attending sessions at Agile on the Beach… I’ve tried to record the sessions accurately, without personal embellishment. Be warned: This post is very long. You should use the links below to click ahead to my notes on the sessions that sound interesting…

TFSBuildMaster

Extending the Red Gate SQL Automation Pack TFS Build scripts to create and deploy releases with Deployment Manager or Octopus Deploy

Red Gate recently released a new set of build scripts, specifically designed for TFS Build that allows users to call the Red Gate SQL Automation Pack to build, test and deploy their database. It also makes it easy to publish a NuGet package containing the database scripts to a NuGet repository ready to be picked up by a release management…