Tag Archives: sql server

The DBA Database

Posted on July 31, 2012 by way0utwest

Do you have a DBA database on all your instances? I’ve always kept a small database on all instances, usually standardized with a set of tables and procedures that I used to monitor and track activity on the instance. By … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The DBA Database

Leaving Some Headroom

Posted on July 26, 2012 by way0utwest

I was reading this piece on scaling Dropbox and something caught my eye. It’s a very interesting read, especially if you deal with scaling, and I’d encourage everyone that works with technology to read it. The one thing that really caught my … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Leaving Some Headroom

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