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

Auditing SQL Logins Addendum

One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....

Calculate table size with existing data

Calculate the physical size of a SQL Server database table (data and indexes) , if rows exist . These steps present a...