Tag Archives: Edge Cases

Tomato, Tomato – Assumptions about Regionalization

This month’s TSQL Tuesday prompt is on the topic of assumptions. I’d like to take a brief moment and talk about one of the more insidious and pervasive sources of bugs in TSQL application code I’ve seen over the years. Let’s say I present you with a date: 08/12/2014 Quick! What month am I talking about?  Read more »

July 8, 2014 Posted by: Leave a comment - 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 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