T-SQL Tuesday #088 – The daily (database-related) WTF

Invitation from Kennie Pontoppidan.

The daily (database-related) WTF

Be inspired by the IT horror stories from http://thedailywtf.com, and tell your own daily WTF story. The truly original way developers generated SQL in project X. Or what the grumpy “DBA” imposed on people in project Y. Or how the architect did truly weird “database design” on project Z

One of my favorite dailyWTF stories is the on about the BIG red button.

Could be that someone from within Amazon will tell that the true story of the AWS glitch last week was a T-SQL dynamic query gone bad.. Or that the HSBC online banking outage last month was as simple USE (wrong) database mistake. Or whatever you guys (or that guy over there) did.

T-SQL Tuesday #044 – Second Chance

Invitation and roundup from Bradley Balls.

As a DBA or a Presenter/Speaker we have all had at least one moment we would like back.  The demo didn’t work, you were green and got asked a question you now know in your sleep.  You had a presentation in front of a client, and it all went sideways.  Maybe you logged onto the prod server thinking it was dev and dropped something you shouldn’t have.  These moments serve not just as painful reminders, but also as powerful instruments for learning.  Would you like another shot at getting it right?  WELL NOW’S YOUR CHANCE!   Or I guess actually your…. Second…. Chance.  Your missions should you choose to accept it, tell me one of the moments you had, and most importantly what you learned from it!

First and foremost the rules.

Rule 1: Don’t get yourself fired.  If you almost dropped the prod DB last week, truncated an important table, or took down a prod server during critical business hours, and nobody knows it was you & the people you work for read your blog, you should probably avoid writing about it here.  You want to write about events we can look back on and reflect over, not events HR would *love* to know about.