Stored Procedure Panel at TechEd 2009

Paulette Suddarth has published an announcement to a Tech Ed panel I am participating in next Monday at Tech Ed.

“The dispute about the usage of stored procedures almost seems to be a religious one. Both sides have some strong arguments. Who better to debate the topic than four MVPs, two Microsoft product managers and another industry expert who all live and breath the issues from their own frame of references!

During this panel (PAN67) at Tech Ed North America, the team of experts discuss what they believe are pros and cons of each approach and try to decide when to use each of them. If you’re attending Tech Ed, stop by on Monday, May 11, 09:00 - 10:00 in 501C to get the complete story!”

I don’t want to start the debate early, but there are some cases in which you have to use a stored procedure. 

Go to Paulette’s post for the lineup, and don’t forget to RSVP for Party with Palermo.

Comments

Craig Bowes said on 5.05.2009 at 9:44 AM

I try to avoid words like "Never' and "Always". In general, I prefer NOT to use stored procedures, and instead rely on a decent o/r mapper. But there are definitely places where a stored procedure is a better fit.

Chris Brandsma said on 5.05.2009 at 10:20 AM

I tend to avoid stored procs as well, but I do create them from time to time. I have admins with database access, so I create stored procs for them to complete admin functions so I don't have to create a separate page for them. They are in the database anyway.

Also, there are time when I need to process thru large amounts of data to return a small amount of data (custom aggregation).

Times when I have to update multiple databases/systems, and my code is not the only code needing to do that. I had one system that had to update SQL Server and DB2 at the same time. We did it with a set of sprocs and linked server to DB2.

What I avoid in my sproc: logic.

But I don't make sprocs for anything that can be just as easily expressed in straight sql or via a good orm.

jdn said on 5.05.2009 at 7:24 PM

It's hard to explain (much less defend) in a blog post comment, but a case can be made that the only time to use a sproc is precisely when you have to put logic in it (otherwise, just use an ORM). There are times when this is the right solution.

Felipe Fujiy said on 5.12.2009 at 6:28 PM

How can I download the video??