Abstract:
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.
Agenda:
- 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
Slides:
- Download the deck and code from my Colorado Springs SQL Server User Group talk
- ContainedDB.ppt
- SQL in the City deck – London
Demo Code: ContainedDB.zip
Related Posts
You can read all the posts I’ve written on contained databases by examining that tag
Presentations
You can view my complete speaking schedule here: http://wp.me/P14wgJ-1tV
- Sept 19, 2012 – Colorado Springs SQL Server User Group
- July 13-14 – SQL in the City – London 2012
- May 19, 2012 – Rocky Mountain Tech Trifecta 2012
- Mar 26-29, 2012 – SQL Server Connections/Dev Connections – Las Vegas
Voice of the DBA 
Comments
3 responses to “Contained Databases in SQL Server 2012”
Thanks for sharing! But when and where did you present this presentation!>?
@DugiDBA
LikeLike
Delivering it today in a few hours. 😉
LikeLike
[…] of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on this recently, and I’m looking forward to seeing where this might go in the […]
LikeLike