Database work

Data that answers the question you actually asked

Database design, migration, reporting and the rescue work that follows a spreadsheet outgrowing itself.

IWhat we do

Three things, done properly.

i

Design

Structure that fits the questions you will need to ask.

ii

Migration

Moving off the spreadsheet that outgrew itself, without losing the history in it.

iii

Reporting

Queries and reports that answer the actual question rather than an approximation of it.

IIWhat goes wrong

The two failures we see most.

We publish these because most of the value in hiring anyone is knowing which mistakes are common, and that knowledge is not worth hiding.

The spreadsheet of record

A shared spreadsheet with no constraints accumulates contradictions silently, and there is no way to tell which row is right.

Reporting off the live system

Heavy queries against production slow the thing everyone is using, and it is always blamed on the network.

IIIHow we work

We tell you what we find.

Including when the answer is that you do not need what you came to ask for. Anyone who never says that is not giving you information, they are giving you an invoice.

Scope

Where something needs a legal opinion, a financial audit or a clinical judgement, we will say so and stop rather than improvise past the edge of what we do.

Start a conversation.

Tell us the situation rather than the service you think you need. We would rather start from your problem.