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 »
Tag Archives: Edge Cases
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 »
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 »
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 »
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 »
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 »