IT:AD:SQL Server:HowTo:SQL:DDL:Stored Procs

As I am an Application developer, I believe logic should be in the app, and the Db just be for storage.

With such an position, I also believe that Stored Procs are only to be used as a last resort, as they obfuscate logic, and create vendor (SQL Server) lock-in.

That said, there are certain things for which Stored Procs are irreplaceable (although less than many think).