Should we still be using stored procedures?

This is a list of articles based around Stored Procedures ordered chronologically, I hope they provide some insight into the way database development practices have developed.

http://grokable.com/2003/11/dont-use-stored-procedures-yet-must-be-suffering-from-nihs-not-invented-here-syndrome/

for

http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx

against
http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

against

http://www.theserverside.com/discussions/thread.tss?thread_id=31953

for

http://www.codinghorror.com/blog/2005/05/stored-procedures-vs-ad-hoc-sql.html

against

http://codebetter.com/jeremymiller/2006/05/25/why-i-do-not-use-stored-procedures/

against
http://weblogs.asp.net/psheriff/archive/2007/02/23/are-you-still-writing-add-edit-delete-code.aspx

against

http://scottwhite.blogspot.co.uk/2008/04/stored-procedures-reconsidered.html

against
http://database-programmer.blogspot.co.uk/2008/06/why-i-do-not-use-orm.html

for

http://stackoverflow.com/questions/82882/stored-procedures-or-or-mappers

against

http://www.richard-banks.org/2008/09/choosing-orm-when-you-can-only-use.html

against

http://sqlblog.com/blogs/peter_debetta/archive/2008/04/03/yet-another-stored-procedure-vs-ad-hoc-query-discussion.aspx

for

http://stackoverflow.com/questions/50346/why-is-parameterized-sql-generated-by-nhibernate-just-as-fast-as-a-stored-proced

performance = same

http://www.sullivansoftdev.com/blog/2008/06/10/sprocs-really/

against

http://blog.robinclowers.com/2008/06/stored-procedures-best-practice.html

against

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/10/30/my-stored-procedure-best-practices-checklist.aspx

objective best practice, neither for or against

http://stackoverflow.com/questions/902549/comparing-hand-written-ado-sprocs-w-nhibernate

against

http://jeffreypalermo.com/blog/stored-procedure-panel-from-tech-ed-09-posted-online/

video is for comments are against

http://geekswithblogs.net/leesblog/archive/2009/05/07/conversation-starter-to-sproc-or-not-to-sproc.aspx

against

http://www.codinginstinct.com/2009/05/never-ending-store-procedure-debate.html

against

http://stackoverflow.com/questions/1761601/is-the-usage-of-stored-procedures-a-bad-practice

http://www.caffeinatedcoder.com/does-it-make-sense-to-use-nhibernate-in-a-sproc-only-shop/

against

http://n0tw0rthy.wordpress.com/2011/05/28/orms-hidden-cost/

for

http://stackoverflow.com/questions/4735127/sql-server-code-reuse-via-stored-procedures-good-or-bad-practice

against

http://lostechies.com/jimmybogard/2012/07/20/choosing-an-orm-strategy/

Objective look at database development

I’m still not sure.

About these ads