Interesting post. One that will no doubt generate some responses here.
I disagree with the scope of the post. Or rather, I sense a compression of incompatible scopes in this editorial. Allow me to explain:
It's somewhat common for SQL Server database professionals to narrowly view the server platform. We (I include myself) see our little niche and believe the rules for our niche apply universally. I don't see this as particularly productive. In fact, I've seen it fly in the face of productivity on a few occassions.
Just look at the differences in design between a data warehouse and an OLTP database for an example.
SQL Server is an extremely complex product - especially 2005. I keep running into folks who find neat uses for different functionality in SQL Server - stuff I would've never thought of. All components, including stored procedures, have their place.
:{> Andy
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics