December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Contained Databases
There is a new set of features in SQL Server 2012 that allow for the creation of a contained database. By definition, a contained database is one that is isolated from other databases and from the instance of SQL Server that it is running on. When contained, no relationship exists between the database and the instance of SQL Server that it is running on. So the database can be moved from one server to another without affecting the usability of the database. Issues such as orphaned database users where the user/login relationship is broken are eliminated with the use of a contained database.
In reality, SQL Server 2012 actually supports partially contained databases. Databases can be created so that they are fully contained ...