Tag Archives: contained databases

Enabling Database Containment for an Instance – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. I wanted to … Continue reading

Posted in Blog | Tagged , , , ,

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 , ,