THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSMS » security   (RSS)
  • 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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on 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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on 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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 18, 2009
  • Connect Digest : 2009-05-10 : please vote!

    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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 10, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement