UpdatedFolders

My manager is telling me to use stored procedures (in context of SQLServer) for the reasons of security (using active directory security groups), faster performance, and easier maintenance. His experience from what I understand is working in a windows dev shop from a while ago.

Arguing against his points, I see it as 1) You can control access to pages or functionality application side 2) Increased performance gains is negligible for our apps as we don't have much traffic. 3) Maintenance may be debatable. Have to now source control database code.

Typically, I have a wrapper around an odbc library that connects to our database instance. I define my SQL queries in the codebase and use prepared statements.

I frankly was a little mad when he questioned my lack of stored procedure usage, but not my call if he wants me to do it this way.

Anyways, I'm looking to start a discussion on this as I like insight from fellow developers on how they've used stored procedures in their career.