fmuzul (3/11/2013)
BOL is written by Microsoft. This is not an independent point of view.
They want to convince the reader that s.p. are good.
Is wiki independent enough for you? http://en.wikipedia.org/wiki/Stored_procedure
Typical use for stored procedures include data validation (integrated into the database) or access control mechanisms. Furthermore, stored procedures can consolidate and centralize logic that was originally implemented in applications. Extensive or complex processing that requires execution of several SQL statements is moved into stored procedures, and all applications call the procedures
You can contribute your opposite independent opinion there too.
I have similar sort of experience as stated by you (with a small exclusion, my first programming language was Assembler for IBM mainframes S360/370) but I have nothing against wide use of stored procedures within appropriate architectural system design. Also, I have nothing against using ad-hoc queries embedded into code for the relevant designs. Also, I have nothing against using ORMs.
It's all depends!
I don't think that universal best approach exist.
There are different options for different situations and these options have nothing to do with DBA's preferences.