Finding the Default Trace File

A post more for me than for anyone else, since I’ll look for something in the default trace and I...

SSAS: Duplicate Attribute Key Error

One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error.  The error message...

The Fantastic 12 of SQL Server 2012

The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the...

Updated SQL Rockstar Blogger Rankings

This morning, Thomas LaRock (blog|@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to...

Service Broker Sample: Multi-Threading

Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...

Which SELECT * Is Better?

The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...

Denali — Day 7: Contained Database

Denali – Day 7 : Contained Database

Contained database is another new feature for sql server 2012 – Denali, earlier version has a big...

Moving from Droid X to Droid Razr Maxx

It’s been not quite two years since I moved from a Blackberry to a Droid X. The X turned out...

My Evolving Goals for Attending Conferences

The first conference I went to back in 1999 I attended every session, the bonus sessions, the breakfasts, everything. It...

SQLSaturday #158 NYC Event Update! - Spread the word...

It's about three months to  to SQLSaturday #158  in NYC, and we're hard at work nailing down all the little...