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.

Richard Howard square

My glorious day in court with “Passport Profiteer” Richard Howard from copycat website British Passport Services

A few months back I wrote about how I had been tricked by copycat website “British Passport Services” (BPS). I wrote about how they had been threatening to take me to court and how I was just one of many people who were currently being harassed by them regarding unfair demands for payment. It is reported that the website owner,…

User

Source controlling database users

How should you source control database users? This topic came up a couple of times in the last week. Once at the inaugural Redgate database source control training day on Wednesday and once or twice at SQL Saturday Exeter, when somewhere in between the foot jenga, pirate hats and explosive Phil Factor unmasking (if you believe it?) I found some…

Branching

Two different types of “Release Branch”

When devising the first workshop for the new Redgate training program, Steve Jones (b|t) and I got into a bit of a debate about branching. Upon reflection, it’s obvious why. People often use the term ‘release branch’ – but they can mean different things.  It is important to be clear. I did some Googling and I couldn’t find consistent terminology…

BPS square screenshot

I’ve been caught out by copycat website “British Passport Services”

UPDATE: Since I first posted this I have had my day in court and I won! Details here: My glorious day in court with “Passport Profiteer” Richard Howard from copycat website British Passport Services. *** I apologise in advance. This one might get a bit rant-y. I consider myself pretty tech savvy… I configure software for a living. I built this…

SoC logo

Managing performance when working with large amounts of static data with Redgate SQL Source Control

This post is for Redgate SQL Source Control users who have large amounts of data in source control and experience performance issues as a result. The objective:  source control appropriate data All database developers should be keeping their database schema in source control. This is the foundation of any fit for purpose change management process, reliable testing or deployment pipeline.…

TechnicalDebtSquare

The technical debt singularity

As always, Wikipedia does a pretty good job of defining well established ideas and the hypothesis of the technological singularity is no different: http://en.wikipedia.org/wiki/Technological_singularity While the term ‘technological singularity’ is credited to Von Neumann in 1958, my favourite definition of the singularity (for the purposes of this blog post and despite the fact he never actually used the word) was…

Octo Logo

How I configured Red Gate SQL Release and Octopus Deploy to deploy SQL Server databases

Earlier this year I documented how I configured Octopus Deploy to use Red Gate’s SQL CI product to deploy SQL Server databases. Since then Red Gate has released a product that is better suited to the task: SQL Release. The point with SQL Release is that the creation of the upgrade script and other associated deployment resources (more on what…

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 (you may need to edit default permissions) 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…