Yearly Archives: 2012

Obfuscated T-SQL Holiday Cards

As a student I was always a great fan of the International Obfuscated C Code Contest.  If you’re not familiar with obfuscation contests, they’re basically a two part brain teaser for coders.  The first part, and the one I find really satisfying, is to write code to do some task in a completely non-obvious way  Read more »

December 22, 2012 Posted by: 3 Comments - Permalink

Troubleshooting “A severe error occurred on the current command.”

I thought it might be useful to start a semi-regular series of entries on troubleshooting for the SQL Server developer. Google has come to my rescue lo, these many times: this is my way of returning the favor. For this first entry I thought I’d tackle one of the more mysterious-looking runtime errors I see  Read more »

March 21, 2012 Posted by: 6 Comments - Permalink

Speaking at SQLSaturday #111 in Atlanta on April 14

A month from today on April 14, 2012 I’ll be speaking at SQLSaturday #111 in Atlanta, GA (or, more precisely, in Alpharetta, GA).  This will be my first trip to Georgia and I’m delighted to be able to present alongside some of the biggest names in the SQL Server community.  It’s a great honor to be  Read more »

March 14, 2012 Posted by: Leave a comment - Permalink

Submit to speak at SQLSaturday Houston by March 15

SQLSaturday #107 in Houston is coming up on April 21, 2012.  The list of submitted sessions so far is fantastic, but ultimately incomplete if you have not yet added yours to the mix.  The deadline for Houston is a week from today on March 15, so don’t delay! SQLSaturdays are a great first time speaking  Read more »

March 8, 2012 Posted by: Leave a comment - Permalink

Using Excel to parse Set Statistics IO output

When tuning T-SQL, “set statistics io on” is definitely your friend. However, I know I cannot be the only developer whose eyes glaze over when I flip over to the Messages tab in SSMS and am greeted with this: That 58-line monstrosity is brought to us by our friend sp_help. Scanning through all that output  Read more »

March 7, 2012 Posted by: 12 Comments - Permalink

Speaking at PASS SQLRally 2012 in Dallas, TX

I am humbled and delighted to announce that my session Edge Case Testing for the Database Professional was chosen as a community pick for SQLRally 2012 in Dallas.  I feel honored and privileged to have this opportunity and I thank each of you for your support through the voting process. SQLRally Dallas 2012 will be  Read more »

February 27, 2012 Posted by: 2 Comments - Permalink

Data Type Conversions with Coalesce and IsNull

One topic I have spoken on a few times in the past few months, but have not elaborated on a great deal, is the issue of bugs caused by data type conversions when using the IsNull expression in T-SQL.  This is a relatively subtle issue, though, and deserving of some attention, so I thought I  Read more »

February 22, 2012 Posted by: 1 Comment - Permalink

SQLRally Dallas 2012 – Community Voting

It’s that time of year!  The pre-cons and regular sessions for SQLRally Dallas 2012 have been announced and it is already looking like an exciting event.  I was fortunate enough to attend SQLRally Orlando 2011 and I had a fantastic time. My session Edge Case Testing for the Database Professional has proceeded to the voting  Read more »

February 17, 2012 Posted by: 1 Comment - Permalink

Speaking at Houston Area SQL Server User Group 2/14

I am speaking on Edge Case Testing for Database Professional at the Houston Area SQL Server User Group meeting on 2/14/2012 at 11:30 AM.  Further details and directions are available here. In this presentation I go over the basics of test case and test plan creation and cover the 9 main areas of edge case testing  Read more »

February 14, 2012 Posted by: Leave a comment - Permalink