Data Pro, What's Your Groundhog Day Flashback?
I am willing to argue that Groundhog Day is THE WEIRDEST HOLIDAY of them all, at least in the USA and Canada. For international readers, this is a holiday based on a superstition from early German-speaking settlers that if a groundhog emerges from its den on this day, February 2nd, and sees its shadow due to clear weather, we will have six extra weeks of winter. If it cannot see its shadow due to cloudiness, spring will arrive early. Makes perfect sense, right?
The US capital of Groundhog Day is Punxsutawney, Pennsylvania where news camera crews flock to see the local groundhog prognosticator, Punxsutawney Phil, make his prediction. And he's terrible. I mean really bad. Punxsutawney Phil is wrong more often than not. According to a USA Today, ye olde groundhog has been wrong 15 times and right 13 times since 1998, about what you could expect from flipping a coin.
But the majority of people over 30, when asked about Groundhog Day, wouldn't mention the holiday and instead would dive into their favorite part of the famous 1993 movie Groundhog Day starring the inimitable Bill Murray as the weatherman Phil Connors, a man who is basically a jerk. And for some magical reason, Phil is stuck in a time loop in which he must relive Groundhog Day again and again.
Each day, he awakens to Sonny & Cher's "I Got You Babe" and each day he attempts to live the day differently to break the loop. There are many funny scenes in which he tries zany methods to break the loop, but each day he reawakens to "I Got You Babe". It is only after Phil is able to change himself, in effect becoming a good and unselfish person, that he is able to break the loop and move forward in life.
The movie was only a modest success at its release. But over time, its popularity and critical acclaim grew until now, where it is considered one of the Top 10 Comedy Movies of all time. The expression "groundhog day" has entered the popular lexicon for any scenario in which a person is hopelessly stuck doing the same thing day after day. And is now frequently imitated in many other forms of entertainment, having its own entry on the website TVTropes, and appearing in other movie genres, such as Edge of Tomorrow (Sci-Fi) and Happy Death Day (Horror).
One of the major themes of the movie is as an allegory of self-improvement, since our hero is trapped in a time loop where escape is only possible by accumulating knowledge through multiple passes. It is such a popular opening for conversations about self-improvement that you can find lots of online discussions featuring the movie as well as plenty of articles in the popular press like this one.
I've touched on the theme of looping endlessly through the same technical mistakes over and over even in my own writing, like in this article about SQL Injection at Database Trends & Applications Magazine and this one entitled The Basics are Still Difficult.
So here's your challenge... what are the technical mistakes that you keep seeing repeated over and over again? I'll put a handful of my favorites here since I lecture on this topic all the time, but I want to see your response in the Comments here. What are the things in your career as a data professional that keep popping up over and over again, like a bad dream?
- backups that were not checked for corruption
- backups that were not subjected to a recovery test to ensure they can be used once recovered
- leaving all server and database configuration settings at the defaults
- leaving important Windows Server settings at the default, such as Power Setting, Instant File Initialization, Large Pages in Memory, and Lock Pages in Memory (where appropriate)
- not monitoring SQL Server applications
- not checking logs
- not setting up Error Log alerting
- selecting the wrong data types for a given table
- poor indexing
- knee-jerk troubleshooting
- lack of standardization across SQL Servers
- no patching process
- ... and the list goes on. What are you Groundhog Day issues?
Looking forward to your insight! Cheers,
Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.