Several years ago there was a big WTF moment for me when I read Frans Bouma's post refuting all of the claims people made for using stored procedures.

Jeff Atwood summarizes Fran's post here.

Every reason I had ever heard for using them over inline SQL was addressed. Ad-hoc (inline) SQL is brittle, it's easier to secure access to data in the database, and performance. The latter being the primary reason why I chose stored procedures.

I don't really have any arguments against their enlightening views. I'll even add to that the idea that if your database logic is in your database, you are tied to that database. It seems the general consensus is that a mixture of stored procedures (for specialized situations) and inline sql (for crud) is the way to go.

So why on earth do I still use stored procedures?

More...