Speaking at SALSSA June 15th 2011:Understanding Storage Systems and SQL Server

I am very exicted to be speaking at the San Antonio PASS chapter SALSSA! It’s been way to long and...

SQL Server Instant File Initialization (PQW)

Bluntly put, this is something that you always want to be taking advantage of.
As a Database Administrator I’m always on...

SSAS - Understanding KeyColumns Dimension Property

For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to...

SSAS Maestro - Day 1 - Redux

Well it’s been an exciting couple of weeks leading up to this course. We have tweaked what we could in...

SSIS Fuzzy Lookup Error

A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...

Time for a Little PD

No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...

What is the best value for Fill Factor in SQL Server?

Introduction
When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to...

What’s a Disaster?

In working on my Preparation for Disaster presentation and doing research, one of the questions that came up early for...

Database Owner - Error Message

Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.

You...

Don't touch that Maintenance Plan Job

Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...