Microsoft SQL Server 2012 RC0 is Now Available for Download!

November 17, 2011 - Redmond, WA - Well, we knew it was coming, but the timing was a bit of a surprise for...

SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts

Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...

Degenerate Dimensions

Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...

Stop SOPA…it already happened in Denmark #StopSOPA

I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....

SQL Server A to Z – Views

Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...

Identify Risk Early

One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...

DBA in Space: Behind the Scenes Part 3

This is a continuation of my DBA in Space journal.
 

Friday, September 16, 2011
OMG. (This is the first time in my...

SSWUG SSIS Expo Event This Friday

Home Sweet Cubicle
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave...

Table Hierarchy goes CS

At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity.  The first few rounds, I neglected Case Sensitivity and never...

Table Hierarchy goes CS

At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity.  The...