Get 1% better daily. Development resource sharing made easy. Post, comment, or upvote to show your contribution and support other developers! 🙌

⚠️ Please do not post any promotional resources.

Dev Squad

Bad days can disrupt your emotional and psychological state. Learning how to cope and recover from them is essential for maintaining mental health and overall well-being.

Sometimes it will ruin your day

I can’t remember the last time I manually ran an UPDATE command where I didn’t start it with ‘BEGIN;’ for precisely this reason.

Remember to always test commands on the developer database!

It happened to me a month ago, had to restore from backups as it wasn’t run in transaction.

Yes. I remember being in a rush once and forgot to add the WHERE clauses. For SQL Server, I at least had the foresight to add table versioning to have a change log of records over a 6 month period.