TSQL Challenge 63 – Update

Categories: News, Professional, Scripts, SSC
Comments: No Comments
Published on: November 14, 2011

If you recall, I like Sudoku.  I even posted a script for solving it via TSQL.  I went so far as to enter my script into a TSQL Challenge.  That all started way back in August.  Today, I have an update!!

I was notified this morning from BeyondRelational.com that I have earned a new badge.  Cool, what’s the badge?  I clicked the link and it took me to this badge.
Huh?  I’m a winner of the SQL Sudoku Challenge?  Awesome!

Looking it over, I am winner #3.  This means I could have done better with my solution.   And looking at the other solution stats, it appears I will need to find time to see what the others did to make their solutions go sooooo fast.  I have some learning to do – woohoo.

So, now that means I need to post my solution.

[codesyntax lang=”tsql”]



Sadly, that is not the most recent version of the script that I had.  I had intended on submitting this version, which is still slightly faster.

[codesyntax lang=”tsql”]


Still, I am certain that (without having looked at the other winning solutions) this is not on par with the best solutions.  And I have a lot to learn.

SQLInspire NYC 2011

Categories: News, Professional, SSC
Comments: 2 Comments
Published on: November 14, 2011

I sit here in a hotel room as I reminisce on this past weekend.  This last weekend began with a red-eye trip from Salt Lake to New York.  The reason for taking that trip was merely to attend SQLInspire – oh and to support the community.

This event was organized by a friend and some of his friends (whom I got to finally meet this weekend).  That friend is Robert Pearl.  Some of his friends (until now were my online acquaintances) include Mike Coles, Brian Moran, Andy Leonard, Melissa Demsak and Matt Velic.  I also had the chance to meet Tom LaRock and re-meet Steve Jones.

The premise of the event is to Inspire Database professionals to continue in the field or improve in the field in some way.  Due to that premise, there was very little tech talk.  Which is probably a good thing because I was having a hard enough time staying awake ;).

I could talk about all of the talks, but I want to recap just one of the talks and then discuss something entirely different for a bit.

The one talk that I found really moving was by Tom LaRock (whose daughter bears the same name as my oldest daughter).  His talk was titled “Someday.”  And for most of the talk you could see me  largely agreeing to what he was saying.  In short, there are “Somedays” that are more important than others.  Don’t be too caught up to let those pass you by.  A “Someday” with your children is far more important than that email you are sending.  Don’t get too caught up that you are passing by what you value most and where you would like to be (re: goals).  The smart alek in me really wanted to ask him during Q&A how to get on his blogroll.  Purely because of a comment he made on his last Rankings update about James Serra (Oct 3, 2011).

Outside of the speeches, there was another thing that was both entertaining and inspirational.  Despite the best efforts of the organizers, it seemed that Halloweem, NYC or something was conspiring against them to make things go awry.  From a computer glitch that caused the attendee list to disappear from the security system, to late arriving donuts, to white-screens raising and lowering throughout Bobby Tables’ presentation and little things like that; it seemed the event was destined for problems.

Not missing a beat though, those issues just kept getting corrected (it’s what DBAs do anyway).  Had I known about this dude though – I might have avoided the event.  OK, I would have just avoided visiting Times Square after 5PM.

Last words:  This event was also to help people network.  Networking time was built into the schedule.  Very good move Robert, Brian, Andy and Gang!!

page 1 of 1

November 2011
« Oct   Dec »

Welcome , today is Monday, January 27, 2020