THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 11
SQL Server 2011
SQL Server v.Next (Denali) : More on contained databases and "contained users"
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 ...
December 10, 2010
For shared SQL Server providers : hiding your list of databases from customers
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 ...
July 19, 2009
Connect Digest : 2009-07-18
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 ...
July 18, 2009
Brought to you by