Microsoft Azure Portal Preview looks promising !

This is one of those posts which is pending for a very long time. I was pretty excited when Azure...

PASS Summit – What Does It Mean To Me?

PASS Summit – what does it mean to me? So listen, I’m not perfect. I will never claim to be and...

Passion

I know I tend to be overly passionate. It’s something that has gotten me into trouble in the past. It’s...

Reducing the Disk Size of a Hyper-V Virtual Machine

Have you ever created a Hyper-V virtual machine and later needed to change the size of the disk on the...

SQL Server 2014 – How to add features to existing instance ?

SQL Server 2014 – How to add features to existing instance ? :-
1) Start installation center

2) Run Global Rule, You need to...

SSIS Parent-Child Architecture in Package Deployment Mode

This is the second in a series of posts about SSIS parent-child architecture.  You can find the index page here.
In...

T-SQL Window Functions – Part 1: The OVER() Clause

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...

T-SQL Window Functions – Part 2: Ranking Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...

Why Is your datetime saved as a bigint anyway?

Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.

On...

Worst Day As A DBA

I remember the day pretty vividly, it was in the summer months and I was as green as green can...