Monthly Archives: April 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

Too Many Bricks, Too Much Data

Posted on April 3, 2012 by way0utwest

At one point in my career I was working on a new application and we were debating about storing certain metrics related to the application usage and customer’s behavior. My boss asked for my opinion and I said that more … Continue reading →

Posted in Editorial | Tagged | Comments Off on Too Many Bricks, Too Much Data