Learn how to convert the first_page, root_page, first_iam_page and general page pointers from hexadecimal to a human readable format.

Implicit conversions are bad for performance as they may cause index scans instead of index seeks. Learn how to avoid this when using the uniqueidentifier data type.

Last week I attended the Miracle Open World 2011 conference. As in the previous years the 80% content, 80% social moniker held true to its reputation. My legs and arms are still sore from carrying four-man rubber rings to the top of the four-story waterslide – not the typical aftermath of a conference. I met a lot of new awesome people and managed to pull of a couple of presentations with decent success as well, judging from the responses I’ve had so far. I’ve included the slides & demo code for the presentations below. Anatomy of an MDF File...

It’s now been roughly 42 weeks since I last wrote a blog entry, phew, time flies! I’ve been busy, one week became two weeks, a month, half a year and before long the tumbleweeds start drifting by. I originally setup the blog back in ‘06 to blog about my ventures in the World Series of Poker. In a moment of temporary insanity, I decided to write my own blog engine as a fun project – reviving my previous homemade blog engine written in in VB, the horror. While it was a fun project initially, keeping it up to date,...