Sometimes I'm amazed at my own stupidity..I don't want to go into a whole lot of detail here, but yesterday at work I needed to take data that was in one database in our school district and import it into another database. How exactly you do this differs from program to program, but the basic idea is pretty much the same as what you did in elementary school when your teacher gave you a list of definitions on one side of the page and a list of terms on the other and you drew lines from the correct word to the correct term. On the computer, though, there's no margin for error. The computer's going to do what you tell it to do, and so you need to make sure that you have the correct word matched up with the correct definition.
I didn't. And I didn't bother to check, either.
Well, and to be fair to myself, I didn't exactly miss matching the two items--I just matched them incorrectly. The terms I was matching were student birthdates, and I correctly matched the "Date of Birth" field in the first database with the "Birthdate" field in the second database. The problem was that I also had to select the FORMAT of the date. The date was in MM/DD/YYYY format (Today would be 09/30/2011), but in a rush to get this job done, I selected DD/MM/YYYY. I then hit the "Import" button and a message popped up something like this:
"You are about to make permanent changes to the database. Once these changes are applied they cannot be undone. ARE YOU SURE YOU WISH TO CONTINUE?"
What I SHOULD have done at that point was stop, leave the live database system, and go into our identical "sandbox" site and run the test there. Had I done that, I would have seen the error. But I didn't have time for that, so I just hit the "Yes" button and let the program go.
Once the import had finished, I hit the "Report" button and saw that--of the 2,300 or so records I was trying to import--about 1,200 of them failed. I knew something was wrong, and I very quickly figured out what it was. With the days and months reversed, many of the records errored out. A birth date of 07/24/2001, for example, SHOULD have been read by the computer as July 24th, 2001, but the program was doing what I told it to do (day first and then month) and was trying to make it the 7th day of the 24th month of 2001. There obviously is no such month, so nothing was written to that record. That happened to about 1,200 student records.
Worse than that, though, was that the program SUCCEEDED in importing the other 1,100 records. This was worse because the information that was now in the system was wrong! A student who should have had a birth date of February 9th, 1999 instead had a birthday of September 2, 1999. I poked around in the system, and there was no way for me to erase the birthdates on my own. I tried reimporting the information a second time with the information reversed, and this worked, but now those students had TWO birthdates. I called the vendor responsible for the second program and asked if they could fix the issue for me, and they said yes, but since the issue was my fault and I'd admitted it was my fault, it would cost $600 for them to fix it. Screw that, I thought to myself, so I started doing what I had to do: I spent five hours clicking on 1,100 student accounts and deleting the incorrect birthdates. Five hours of work that I could have avoided if I'd taken 20 minutes and tested the import first.
I remember when I got my first power tool. It was hardly even a power tool, to be frank: it was an inexpensive cordless drill. This was years ago, not too long after Lisa and I had married. I'd been hanging blinds in every window of our new house, and I'd been doing it manually with a handheld Phillips screwdriver. After nearly wearing a blister on my thumb I went out to Lowe's and bought the cordless drill, and after letting it charge for a while I eagerly got it out and took it to the window over our kitchen sink. I stood on a step ladder and put a screw against the drywall above the window, lined the bit of the cordless drill up with the screw, and hit the button on the cordless drill. Immediately the screw spun wildly out of position, I lost my balance and fell, dragging the spinning drill in a line across the drywall above the window, creating a scar all the way across, and my knee came up and hit the window, cracking the glass. I fell onto the kitchen counter, bending the sink faucet, which started leaking water.
I walked into the family room on the lower level and told my wife, "Power tools are great. They help you make bigger mistakes faster!"
I think that's what happened to me yesterday, too...

A lot of people are complaining about the new Facebook design. Let's be more frank: A lot of people are WHINING about the new Facebook design. But I'm much less worried about the latest Facebook version than I am worried about what's coming.
Yesterday I didn't have time to make a blog post, and now I find that, as a result, I'm probably too late with this post, and

I have a big head.
I've seen this weekend coming on my calendar for about six weeks now, and I've been trying to figure out what I was going to say about the tenth anniversary of 9/11. I don't want to rehash the events of the day and how they affected me. I already did that in
Here's an update on a post that's almost two years old...
Part of the reality of my job is that almost every day I'm at work--and usually several times a day--I'm asked by someone else to do something that I've never done before. That hasn't always been the case. When I was a classroom teacher I pretty much did the same thing every day. Sure, as an English teacher, some days I was teaching grammar, some days I was teaching writing, and other days some type of literature, but I pretty much came to work each day with a clear idea of what was going to happen that day and how I was going to do it.
Today a teacher at work asked me, with a completely straight face, why I wouldn't load a piece of software that she had bought in a store and paid $9.99 for onto EVERY student computer in two elementary schools (about 130 computers). When I explained to her that the license--that big, long agreement that she hit "Agree" to when she first installed the computer--granted her the right to install that piece of software on ONE computer, she made a "Pffff" sound with her mouth and said, "Oh! That company isn't even around anymore! What difference does it make?"