Skip to content

Ideas Illustrated

Survival Skills for the Information Age

Menu
  • About
  • Resources
  • Subscribers
Menu

Relearning an Old Lesson

Posted on October 13, 2010

Anyone who’s ever used a computer has — at some point — lost a carefully-crafted sequence of ones and zeros to the unforgiving gods of the digital realm. Every time it happens, you mourn, you rage against the sky, you re-write and you move on. Each time, you add another rule-of-thumb to the mental checklist designed to minimize the losses or at least ease the reconstruction effort of the next minor catastrophe. In the end, it all boils down to one simple rule. That’s right, ladies and gentleman: save often.

I was reminded of this basic lesson when I arrived at work on Monday and was presented with an odd little e-mail from the data warehouse team. Why had I changed the user profile for the data feed to the Marketing server? Hmm … I hadn’t actually done anything to the profile and, when I checked the database, it was more than altered, it was completely missing. Not a big deal, I thought, because I could always re-instate the permissions from another source and then we’d be ready to continue with the upload process. Easy peasy.

But upon closer inspection of the tables, it became clear that something was slightly off. First of all, the tables were old — not really old but still missing a few months of data. Then I checked a few structural updates I’d made the previous week and they weren’t there. Several new procedures were missing, too, as were a couple of new tables and even recently stored files on the shared network. Not good. It was becoming pretty apparent that the DBA team had done something major over the weekend and that everything on our server had been rolled back to July. Further investigation suggested that they had done their overhaul without a backup.

It took two days of effort for everyone to finally accept that the information was just plain gone. I began the re-building effort rather reluctantly but it soon dawned on me that this whole incident was really a blessing in disguise. Our department had been working without a net for too long — our server was a creaky old SQL 2000 box leftover from a failed project and we’d never really had any official technical support. Now, we’ll probably be able to switch the whole thing over to a full-fledged production server with upgraded software, a routine maintenance plan and — best of all — a robust data backup procedure.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search

Categories

  • Design (15)
  • Education (1)
  • Favorites (5)
  • Infographics (14)
  • Information (44)
  • Programming (3)
  • Uncategorized (1)
  • Urban Planning (1)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tags

American Film Architecture Bias Charts D3 Data Database Management Data Science Data Visualization Design Principles Disinformation Dog Donald Trump Egypt Filter Graphs Industrial Design Infographics Information Design Information Overload John Boyd Journalism Knowledge Management List Map Media Obama Occupations OODA Loop Organization Politics Privacy Propaganda Signage Simplicity Snow Day Social Media Symbols Tableau TV Remote Unemployment Usability User Experience Visualization Words

Popular Posts

  • Visualizing English Word Origins
  • Most Popular Word Roots in U.S. Place Names
  • Three Rules of PowerPoint
  • Donald Trump and the Truth Bubble
  • Addressing the Loss of Institutional Memory
  • King Bhumibol is a Noob
  • Channel Surfing Ain’t What it Used to Be
  • Wisconsin Voters Banished to NULL Island
  • The Short-Circuiting of the American Mind (Part 2: Generation Q)
©2023 Ideas Illustrated | Design: Newspaperly WordPress Theme