T-SQL Tuesday #051: Place Your Bets

Comments: 27 Comments
Published on: February 4, 2014

Place Your Bets

chipsAll bets on the table please.  This is the last call for bets, no new bets will be allowed.

This marks the 51st invitation for TSQL Tuesday.  This also marks what should have been the month of the first SQL Saturday event in Las Vegas.  But the house lost on that event so it was pushed out to April 5th.

With that loss and the subsequent push, it is time for you to put on your Poker Face.  This month TSQL Tuesday is taking on a Vegas theme.  I want to know about the gambles within your databases or not within your databases that you have seen over the years.

When has somebody (a CTO, Developer, Business User) placed a bet that was far too risky in your opinion?  What kinds of gambles have been parlayed into catastrophes that could have been easily avoided?  Once you are all in on these dogs and the aggregate limit has been reached, I want to know the handicap and how you fixed it.

Here are some examples.

  1. I encountered a Sharepoint database server that had a 940 GB error log.  The log was locked by antivirus software and couldn’t be cycled.  Upon getting that resolved, I found the log was growing at about 500 MB an hour.  There was a problem with Sharepoint talking to Active Directory.
  2. A developer wrote a cursor that ran for 36 hours.  Upon investigation, the cursor was re-written into a set-based script that ran in 42 seconds.
  3. A 3rd party hosting service stopped SQL Server Services and deleted the system databases.  The line on this bet was that they would have less than 15 minutes of outage and minimal revenue loss.  The reality in this case was a sucker bet.  They lost 4hrs of uptime and nearly 2 million dollars for the client.

I will leave it to you to offer up tokes and/or to discuss any trends this may have revealed to you while producing the rundown.  Have fun with it and remember, with databases a big bet is not necessarily worth the risk.

What is T-SQL Tuesday?

TSQL2sDay150x150T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and follows the requirements below. Additionally, if you are interested in hosting a future T-SQL Tuesday, contact Adam Machanic on his blog.

How to Participate

  • Your post must be published between 00:00 GMT Tuesday, Fevrier 11e, 2014, and 00:00 GMT Wednesday Fevrier 12e, 2014.
  • Your post must contain the T-SQL Tuesday logo from above and the image should link back to this blog post.
  • Trackbacks should work. But, please do add a link to your post in the comments section below so everyone can see your work.
  • Tweet about your post using the hash tag #TSQL2sDay.
27 Comments - Leave a comment
  1. […] month’s T-SQL Tuesday topic, hosted by fellow MCM Jason Brimhall (@sqlrnnr) is on the times when a bet has had to be made, when […]

  2. […] It’s been an incredibly long time since I last blogged, but this month’s T-SQL Tuesday topic was so juicy, I had to throw down. This month’s event is being hosted by Jason Brimhall and is on the topic of risky bets in IT. […]

  3. […] Want to read more T-SQL Tuesday stories? Jason Brimhall is this month’s host. […]

  4. Matt Velic says:

    I think the pingback should work, but just in case it doesn’t, here we go: http://mattvelic.com/tsql-tuesday-51/

  5. […] topic number 51 is outstanding.  Hosting Adam Machanic‘s rotating blog party this month is Jason Brimhall aka Twitter @SQLRnnr who asks ”when has somebody (a CTO, Developer, Business User) placed a […]

  6. Russ Thomas says:

    Thanks for hosting – great topic. Here’s my post: http://wp.me/p2TlyL-cR I’ll see your bad decision and raise you a horrible one.

  7. […] month’s event. He used to live in Las Vegas, and with that theme in mind, he calls for you to Place Your Bets.  That’s a time when someone has gambled, or risked something on an application, […]

  8. Robert Pearl says:

    Hey, Jason. THanks for dealing, I mean hosting. Thanks for letting me know in advance too :-P

    Here’s my entry:
    ——————–
    http://www.sqlservercentral.com/blogs/pearlknows/2014/02/11/t-sql-tuesday-51-place-your-bets-in-place-upgrade/

  9. […] a topic. Known as T-SQL Tuesday and started by Adam Machanic (Blog | @AdamMachanic), this month’s T-SQL Tuesday topic is hosted by friend and fellow MCM Jason Brimhall (@sqlrnnr) and he wants us to blog about bets. […]

  10. […] you are interested, the invite for T-SQL Tuesday is here and the deadline for submission is not until Midnight GMT on 12 […]

  11. […] you are interested, the invite for T-SQL Tuesday is here and the deadline for submission is not until Midnight GMT on 12 […]

  12. […] The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. […]

  13. […] The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. […]

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">








Calendar
February 2014
M T W T F S S
« Jan   Mar »
 12
3456789
10111213141516
17181920212223
2425262728  
Content
SQLHelp

SQLHelp


Welcome , today is Friday, October 31, 2014