HomeSQL Server 2012SQL Server 2012 (“Denali”): Contained Databases

Comments

SQL Server 2012 (“Denali”): Contained Databases — 6 Comments

  1. Surely the issue is more that the requirements for using databases in environments that are now very different from when they were first designed by Sybase i.e. cloud environments. This is more so than that sql server has been “plagued” with the problem you describe. That original model has served SQL Server very well and the time has come to decouple the database from server for modern requirements.

    Also, I realise you were not emphasising this but the capability to create a database-specific user without a SQL Server login first became possible in SQL Server 2005. The deliberate and explicit creation of a database user not mapped to a SQL Login (which is the definition of an orphaned user), made it possible since that time to solve the problem of how to create a low-privilege user account that could be impersonated as and when access to a secured resource in the database was needed. My point is that the capability for creating this kind of user has been around for some time.

    Many thanks for the new information – Tony S.

  2. why do I want to comment here? a much more interesting place to comment about the article would be the website I read it on, which was sqlservercentral.com. Why do people insist on doing this?

    • Good question – I prefer to have comments posted on my site so that all the comments are done in one place instead of comments being made on different sites for the same posting. It seems readers would benefit by having the comments in one place, but not a big deal.

  3. How do you set the file locations with a contained database? If I want my database and logs to be on different drives (best practice) I need to be able to set file locations for both, but these settings would seem to be very server specific and thus would have to be re-set for the new server if the database was moved.

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>