• 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