Sadly I share the experience of seeing more bad coding instead of less the last couple of years, it should be the other way around. What I think contributes to better work is starting a new piece of code with CREATE VIEW instead of CREATE PROCEDURE. Sqlserver as all databases is set-based and procedural code should be avoided as much as possible for lots of reasons. In new work I hardly ever use sp's anymore.