SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Contained Databases in SQL Server 2012

One of the problems with databases in SQL Server is the dependency of the database on various parts of the host instance. In SQL Server 2012 there is an enhancement to the database format that allows for partial containment of your database, and will make the movement, migration, and management of the databases much simpler. This session introduces the new database structure and explains how it can be used in your environment.

This talk looks at the new partially contained databases in SQL Server 2012.


  • What is a contained database
  • Contained databases in SQL Server 2012
  • The Future

The talk will demonstrate the issues with uncontained databases, provide demos on how to create and alter contained databases, look at security and collation issues in SQL Server and speculate on the future.

Level: 200

Length: 60 minutes

Demo Code: ContainedDB.zip

Slides: ContainedDB.ppt

Related Posts:

How to Enable Contained Databases in SQL Server 2012

Filed under: Presentations Tagged: ContainedDatabases, presentations, sql server, syndicated

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


Leave a comment on the original post [voiceofthedba.wordpress.com, opens in a new window]

Loading comments...