2011 SQL Rally Evaluations - Reporting Services Boot Camp

I wrote this early in June, but lost it in my blog pile again and just found it…

First and foremost,...

SQL Server Myth on Clustered Index page allocation or B-Tree formation

Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...

How to move the Master database

The catch to moving the Master database is that you must also move the Resource database.  Microsoft states that the...

Foreign Key Hierarchy Update

Today I would like to revisit a post of mine that is rather old.  More precisely, the script in that post needs revisiting.  This is one of my more...

Foreign Key Hierarchy Update

Today I would like to revisit a post of mine that is rather old.  More precisely, the script in that...

Meme Monday – Horoscope

Did you know that your sign may have changed?  I didn’t – at least not until reading the meme Monday announcement.  Most people probably will see no difference in...

Meme Monday – Horoscope

Did you know that your sign may have changed?  I didn’t – at least not until reading the meme Monday announcement....

Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac

Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter

It’s time for July’s Meme Monday post, and...

July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”

July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...

Environment variable in SSIS not being recognized

If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...