Part of a conversation I had at the South Florida Code Camp was what I thought about various features that had been added in SQL 2005. I suspect I have an unusual view in some cases, but maybe not! In any case, here's a summary of that conversation:
HTTP EndPoints. These strike me as something that was added just to check off the SOA/Web Service item on the hot things we need for marketing checklist. Possibly a few people are using them, but in practice exposing a stored proc as a web service doesn't take a lot of code to start with, and we rarely want people connecting directly to the server (should be via some type of middle layer). I guess it's ok to put in the box and if someone uses it, good, and if not - well, it doesn't hurt other than maybe increasing the attack surface.
Schema. I like the change to bring us closer to ANSI compliance, and it cleans up the user owned ugliness. Still, so far I've not seen anyone that managed their security at any level by using schema. Life just doesn't usually fall into nice buckets like that! I would like to see SSMS altered to show schemas as folders under the object, that would make it much easier to see what was where, and it would let us stop naming table to get psuedo groups like TrainingAttendees, TrainingClasses because we would have a Training folder (schema) that would seem obvious. Should be in the box, but for most of us, a single DBO schema is the way to go.
Service Broker. I'm not a convert yet. I like that MS has moved from MSMQ to a native SQL based solution for things like updating subscribers, and many of us have used tables for informal queues for years. Do we need SB, does it save code, etc? So far I'm just not sure. I'm ok with leaving it in the box, for now!
I like that we get new features, but it's always hard to tell which ones will really matter when it's all said and done. It's also hard to know for those of us with limited training time/dollars to figure out which features we really need to learn, and which ones can wait until/if we need it. I'd like to see MS (or PASS) do a better job coaching on that.