March 27, 2008 by Dan Siegel.

My son is scouting for engineering schools, and came across www.engineeringedu.com. He also discovered its jokes page. Apropos my earlier blog today, the site (http://www.engineeringedu.com/jokes.html) features, among others, this little ditty:

New Lyrics to Beatles Song - “Yesterday”

Yesterday,
All those backups seemed a waste of pay.
Now my database has gone away.
Oh I believe in yesterday.

Suddenly,
There’s not half the files there used to be.
And there’s a milestone hanging over me.
The system crashed, so suddenly.

I pushed something wrong,
What it was, I could not say.
Now all my data’s gone,
And I long for yesterday-ay-ay-ay.

Yesterday,
the need for back-ups seemed so far away.
I knew my data was all here to stay,
Now I believe in yesterday.

Posted in Random Thoghts | Print | No Comments »

March 27, 2008 by Dan Siegel.

I always say, “Never train on live data” because if something happens, it’s a “problem,” to say the least. Today I failed to abide by my own words. Guess what, something happened. The database with 98,542 records shrunk a bit — to 6 records. So did my stomach.

Having never seen this before, I called Tech Support. The rep hadn’t seen it either. He put me on hold and found out a couple of the other reps had heard of this. What did it mean? That the database had crashed and I needed to restore it from a backup. And, of course, the firm didn’t think there was a backup! Fortunately, I found a copy of the database file, and all was well. Of course, I strongly recommended that the firm backup the data — and when I return for more training, we’ll use my training databases.

Posted in Software, Random Thoghts | Print | No Comments »