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 ...

In a shared SQL Server hosting environment, there are several problems that can arise when you let your customers use Management Studio to connect and administer their databases.  In the typical case, you give them a single SQL Authentication username and password, and they are supposed to be able to connect only to their database.  By ...

I missed last week because I was having fun up in Canada... mostly without any kind of computer access at all.  It was a nice break, but now I'm back in the thick of things again.  So this week, I am going to try to beef it up a bit to compensate for last week's missing entry. =================================== DELETE vs. DROP I ...

Sorry I'm a day late on this one; yesterday I was fully engulfed by Resource Governor stuff and a filter refreshing problem at work, and then last night I spent the entire evening away from a computer (for the first time in what seems like ages).  Anyway, without further ado, here are the items I noticed this week that I think could use some ...