267
submitted 10 months ago by [email protected] to c/[email protected]
you are viewing a single comment's thread
view the rest of the comments
[-] [email protected] 15 points 10 months ago

A very real problem I ran into in SSMS was I had inadvertently highlighted all parts of the script except the "where" clause and executed it. I thought to myself, "why is this taking so long for such a low impact change?"

I knew running ad-hoc scripts in a production environment was risky, but I accepted it. We had a fresh enough backup already loaded in our sandbox environment and the removed data was quickly restored from there after some cursing and some quick hacking. This happened 6 years ago.

The data that was deleted? All the user accounts of our biggest client. This happened at 10 AM in the morning on a weekday. FML. I was lucky to keep my job.

As an aside, if you do something on my level of stupid, then escalate the issue up the chain of command as quickly as possible. Do not hide it. If you've built up enough good will with your co-workers and bosses, they will rally to your aid. Definitely don't try to hide it. That will almost certainly lead to termination.

Check my war wounds. Every soldier has a story to tell.

[-] [email protected] 3 points 10 months ago

10 AM in the morning

good thing it didn't happen at 10 AM at night, I guess

[-] [email protected] 3 points 10 months ago

It was right after 9 in the afternoon and my eyes were the size of the moon.

load more comments (1 replies)
this post was submitted on 16 Nov 2023
267 points (97.5% liked)

Very Real Tech Pics

1285 readers
3 users here now

There's no place like 127.0.0.1

founded 10 months ago
MODERATORS