Tag Archives: contained databases

Enabling Database Containment for an Instance – #SQLNewBlogger

Posted on October 4, 2017 by way0utwest

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 , , , , | Comments Off on Enabling Database Containment for an Instance – #SQLNewBlogger

Contained Databases – Server Setting Matters

Posted on July 19, 2012 by way0utwest

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

Posted on July 14, 2012 by way0utwest

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

Posted on June 7, 2012 by way0utwest

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 , , | Comments Off on Contained Databases – Preventing Collation Conflicts