Skip to content

Contained Databases in SQL Server 2012

March 29, 2012

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:

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

About these ads

From → Presentations

3 Comments
  1. Thanks for sharing! But when and where did you present this presentation!>?
    @DugiDBA

  2. Delivering it today in a few hours. ;)

Trackbacks & Pingbacks

  1. Enabling Contained Databases in SQL Server 2012 « Voice of the DBA

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 4,635 other followers

%d bloggers like this: