{"id":782,"date":"2014-09-01T16:44:27","date_gmt":"2014-09-01T20:44:27","guid":{"rendered":"http:\/\/www.peteonsoftware.com\/?p=782"},"modified":"2024-04-08T13:04:06","modified_gmt":"2024-04-08T17:04:06","slug":"podcast-episode-22-in-defense-of-stored-procedures","status":"publish","type":"post","link":"https:\/\/www.peteonsoftware.com\/index.php\/2014\/09\/01\/podcast-episode-22-in-defense-of-stored-procedures\/","title":{"rendered":"Podcast Episode 22 – In Defense of Stored Procedures"},"content":{"rendered":"

\"GavelEpisode 22 finds me talking about Stored Procedures. Stored Procedures have gotten a bad rap not just recently, but for over a decade. Stored Procedure apologists don’t always help the matter and misinformation abounds. I take a look at stored procedures and why it isn’t the worst thing in the world if you use them.<\/p>\n

I haven’t forgotten my last podcast about religious arguments and I try to take an honest look at when stored procedures aren’t terrible, when ORMs are best, and when in-line parameterized SQL might be your best option. Too often, I feel that developers are scared of the database because they don’t know it or only have a limited view of what it could be for. In this episode, I look at it from all angles.<\/p>\n

Links Mentioned in this Show:<\/strong>
\nRob’s Original Post<\/a>
\nFrans Bouma’s Reply<\/a>
\nRob’s Rebuttal<\/a>
\nJeff Atwood’s Post<\/a>
\nAyende’s Compromise<\/a>
\nZip Locate<\/a>
\nGooey<\/a><\/p>\n

You can also subscribe to the podcast at any of these places:
\n\"iTunes<\/a> \"RSS<\/a><\/p>\n

Thanks to all the people who listen, and a special thanks to those who have rated me. I really appreciate it.<\/p>\n

The episodes have been archived. Click Here<\/a> to see the archive page.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Episode 22 finds me talking about Stored Procedures. Stored Procedures have gotten a bad rap not just recently, but for over a decade. Stored Procedure apologists don’t always help the matter and misinformation abounds. I …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,87],"tags":[98,4],"class_list":["post-782","post","type-post","status-publish","format-standard","hentry","category-podcasts","category-sql","tag-podcasts","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/comments?post=782"}],"version-history":[{"count":0,"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/782\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/media?parent=782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/categories?post=782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.peteonsoftware.com\/index.php\/wp-json\/wp\/v2\/tags?post=782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}