Tag Archives: contained databases

Contained Databases – Server Setting Matters

In doing some additional testing on contained databases, I decided to create a new database on a new test VM. CREATE DATABASE cdb1 containment = PARTIAL ; To my surprise, I got this error: Msg 12824, Level 16, State 1, … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

AlwaysOn and Contained Databases in SQL Server 2012

This talk is mostly based on contained databases in SQL Server 2012. The first part of the talk goes over the problems with current database movement, the idea of containment, and the implementation in SQL Server 2012. There are demos … Continue reading

Posted in Presentations | Tagged , , , | 1 Comment

Contained Databases – Preventing Collation Conflicts

One of the demos from my Contained Databases talk looks at the issues you can have when your database collation does not match your server collation. I’ll walk through the issue here. I’ll show the issue, and then the fix … Continue reading

Posted in Blog | Tagged , ,

Creating a User without a Login – Contained Databases

In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to enable this, and this post will look at one of the advantages of contained databases: users without logins. Contained Users … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Enabling Contained Databases in SQL Server 2012

One 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 future. This post looks at how … Continue reading

Posted in Blog | Tagged , ,

Contained Databases in SQL Server 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 … Continue reading

Posted in Presentations | Tagged , , , | 3 Comments