How SQL Server stores indexes on variable length columns

In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...

Updated SSMSDeploy Demo Video

This is just a quick note before I head off for work that I have made a new demo video...

SSAS – Hiding Unknown Member

You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that...

PASSMN Call for Presenters and Sponsors

Before the year gets going too far and things are too planned out, I thought I would see if there...

My First Sandy Bridge Desktop System

I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...

Thinking about goals for 2011

The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With...

SSMS Addin Wrapper - Source Code and Usage

Code First, KTHX!
Here, as promised, is the source code for the SSMS wrapper.

Introduction

My apologies for the brief delay on this....

31 Days of SSIS – Override Variables (9/31)

Day number 9 of the 31 Days of SSIS.  If you missed the first week then start by reading the...

The OUTPUT clause

One of the features that I have been using quite a lot lately is the OUTPUT clause.
This clause can be...

SSMSDeploy - Demo Video Available!

Updates

1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to...