It's the 1990s, and this database admin pilot fish is a consultant for a company that rents computers to large customers. "My client has an app that tracks inventory and is used to bill the customers, and I'm responsible for building the forms and making necessary enhancements," says fish.
"One day, a client employee finds records missing and blames me. I know I didn't delete the data, and decide to enhance the forms system to track deleted records in a separate database table. Any records that get deleted will now be moved to the 'deleted' table, along with the additional information of the user making the delete and when it happened.
"Flash forward a couple weeks: The same employee repeats her claim, this time about different records. Accompanied by that employee, I then query the 'deleted' table and look up the record. Hmm -- it seems the complaining employee is the one who deleted the records.
"The odd thing is that she didn't ask me to restore them to the active table. But I never heard from her again about missing records."
Let Sharky hear from you. Send me your true tale of IT life at firstname.lastname@example.org. You'll score a sharp Shark shirt if I use it. Add your comments below, and read some great old tales in the Sharkives.
Get your daily dose of out-takes from the IT Theater of the Absurd delivered directly to your Inbox. Subscribe now to the Daily Shark Newsletter.