Tag Archives: sql server

Enabling Contained Databases in SQL Server 2012

Posted on April 9, 2012 by way0utwest

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 , , | Comments Off on Enabling Contained Databases in SQL Server 2012

SQL Server 2012 Beta Exams

Posted on April 5, 2012 by way0utwest

I signed up for a few of the SQL Server 2012 Beta certification exams, and have been going through them over the last few days. The exams I signed up for are: 071-461 – Querying Microsoft® SQL Server® 2012 071-462 … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Server 2012 Beta Exams

Using 2008 Features in a 2000 Compatibility Database

Posted on April 4, 2012 by way0utwest

I saw a note recently from someone asking if they could use CROSS APPLY on a SQL Server 2008 instance with an older database in SQL 2000 compatibility mode. You can. CREATE DATABASE sql2kCompat ; go ALTER DATABASE SQL2KCompat SET … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using 2008 Features in a 2000 Compatibility Database

My Little Friend

Posted on April 4, 2012 by way0utwest

Say hello to my little friend: This button is my favorite part of Management Studio. It’s on every dialog that I’ve seen in the 2012 version of the tool and I’ve begun using it quite liberally. At a recent talk, … Continue reading →

Posted in Editorial | Tagged | 2 Comments