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...

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...

It's not Business, It's Personal

Hello Dear Reader.  I find myself at this late hour unable to sleep.  Yesterday the slate of speakers for the...

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...

Passion

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

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...

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...

Entity Framework Fluent API and Indexing

With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It’s still pretty...