Long Day

Well… I just spent 10.5 hours at work. Not that I don’t like it there, but it is tiring to do anything for that long. The reason that I stayed late was because we had an issue. It was about 4pm and people are starting to think about leaving at some point in the not-so-distant future. And what do I hear from down the hall in the old programmer office? “OH MY GOD!” Yes this must be good. And it was.

Lets just say that a table that has about 2900 entries managed to find it self with 2900 almost identical entries. An UPDATE query without a WHERE clause was the culprit. When was the last backup? A month ago? Perfect! But with that and a bit of skill and persistence, we were able to get it back to where it was without much trouble. Nothing brings a team together quite like a small crisis. Good times.

Written by Colin Bate