So it’s been a little while since I’ve put out a Friday Shorts – mainly because everything that I’ve been doing has been either so insignificant or requires a blog post all to itself, but without further ado, here’s my shorts…

Get the SQL Server Edition you are using

sqlserver_sql_server_2008_logoRan into a situation where I was a rebuilding an application for someone, this someone did not know whether initially they had deployed the application with the SQL Server Express edition that it came with, or installed a separate version locally on the machine.  Well, a quick SQL Query like the following will solve that issue and let you know exactly what you are currently running…


SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

 OMG!  The Lockout is over!!!!

the-hockey-sweaterSo there is a book that I often read to my son before bed called “The Hockey Sweater”, a book that was often read to me as a child.  The first line of this book is as follows; “The winters of my childhood were long, long seasons. We lived in three places – the school, the church and the skating rink – but our real life was on the skating rink.”    This simple phrase could not be more true when it comes to my attitude towards hockey and the NHL.  The recent announcement of the NHL lockout ending brought along thousands of tweets and blog articles of “die-hard” fans stating that they will be boycotting the NHL.  They will not be attending games, with some people saying they will refuse to even view a game on TV.  Well, I could jump on this bandwagon as well, but I know that deep down inside, even though the owners and the players have most certainly hurt the fans, I will still follow my team religiously through out this shortened season and I will get just as excited as I did when I was 14 watching Les Glorieux hoist their 24th Stanley Cup around the Montreal Forum.   There is no way I could ever boycott that feeling, and IMO there are many many others that feel the same way and live by that same simple phrase from “The Hockey Sweater”  I know there is at least one person anyways, whoever designed our Five dollar bill printed those same words on it 🙂



P.S. – Get this Subban stuff sorted out!!!