SQL Server 2008 R2 SP1 Cumulative Update 2

Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in...

Basic Computed Columns

I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote...

You Are Allowed to Care About Whatever You Want

I wanted to write this because its often overlooked. I care about things that may not interest you, things that...

Going Big with SSDs

Nimbus Data just sold 100TB of SSDs to eBay
I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus...

Top 5 Oracle Nuances I learned Today

I don’t do much with Oracle – at all.  Once in a blue moon, I find a little project to do that might involve Oracle.  I have never put...

Top 5 Oracle Nuances I learned Today

I don’t do much with Oracle – at all.  Once in a blue moon, I find a little project to do...

Compiles and recompiles

I want to spend some time over the next few months looking at query compilation and the plan cache, and...

SSIS - Inferred Member Insert in Fact Table Load

Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...

Steel City SQL User Group

Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL.  I...

Announcing the upcoming Colorado GiveCamp

What is a GiveCamp?

GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...