PAST ME, WHAT WERE YOU THINKING
We all make mistakes.
I certainly have.
I’ll give you a recent one, actually: when we designed the database for SQL ConstantCare®, when we’re storing diagnostic data like wait stats, we thought these 3 columns would be good for identification:
user_id server_name instance_name
Because a single user would never send in data for the same SQL Server name, same instance name, but different data, right? Well, wrong-o, because it turns out:
Some companies reuse the exact same server name in different places (like they have SQLPROD1 in NYC, and another one