posted on Thursday, June 08, 2006 3:34 PM
by
amachanic
Stored procedures vs. ad hoc SQL and related stuff...
Given the recent debates over at
CodeBetter.com on stored procedures vs. ad hoc SQL, how could I not join the fray??
Of course, I could not resist. So, I posted my own views in
an article on Simple-Talk.com. This article is adapted from my upcoming book,
Expert SQL Server 2005, to be published by Apress a bit later this year.
As a result of this article, I got a bunch of fun hate mail in my inbox this morning. Apparently, not everyone agrees with my views. To which I reply, GREAT! That shows that you're thinking for yourself. I'd much rather see thoughtful arguments against my views than blind agreement. Although to be honest, it's not clear that all of the hate mail is from people who've actually thought through these issues very well. Sorry, but, "I've never used stored procedures and never had a problem" is not a good argument -- it's purely anecdotal. Just because you've never had a problem (or didn't realize that you've had a problem?) doesn't mean that there aren't issues. I have personally dealt with more than my fair share of issues caused by developers that didn't realize that direct table access is just a
very bad idea. In most cases. Fine.
So anyway, I invite you to post your own thoughts on this matter
here.
Or, better yet, come tell me in person! Next Friday, June 16 at 1:15 p.m., join me at TechEd for BOF39:
SQL vs. ORM: How can we erase the object-relational wall? Based on the strong opinions people seem to have on these topics, I can almost guarantee that this will be a very lively discussion, not to be missed!
In other TechEd-related news, if you're going to be around Saturday night you should come
Party With Palermo at the Atrium Lounge in Faneuil Hall.
And, on another data-related note, I've been informed that there will be an ADO.NET panel on Tuesday afternoon at the Seaport Hotel. More information
here. Looks like it will be an interesting gathering!