One of the reasons for contained databases (see my previous post) is to allow for a more seamless transition when moving a database from one server to another. One of the biggest complications in doing so is making sure that all of the logins are in place on the new server. Contained databases help solve this issue by creating a new ...

Sorry to call this out in a separate post (I talked about a bunch of SSMS Connect items the other day), but Aaron Nelson (blog | twitter) jogged my memory today about an issue that has gone unfixed for years: the custom coloring for Registered Servers is neither consistent nor global.
For one of my servers, I've chosen a red color to show in the ...

It's been a while since I hosted a true Connect pity party digest, trying to pimp your votes for the issues I think are worthwhile. And okay, some of these bugs haven't been filed in the Denali time frame - but those are still in Denali's version of SSMS. And since we are not expecting a release for a year, and the next CTP won't be ...

This afternoon, Adam Machanic (blog | twitter) reminded me how the current T-SQL debugger in Management Studio is ineffective. Sure, there are some enhancements coming in Denali (I mentioned them briefly yesterday), but there are some real key elements missing. One of the most glaring omissions is the ability to see the contents of ...