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

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

SSIS Fuzzy Lookup Error

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

PASS Update #56-SQLRally 2012 Site Selection

Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than...

What’s a Disaster?

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

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

It’s late but I need to say some words about our local tech event, it is the only one that...

Afterthoughts: SharePoint Saturday Tampa 2011

This past Saturday June 11th, 2011 I had the opportunity to co-present at SharePoint Saturday Tampa thanks to a special invitation...

Non use of persisted data

Working at a client site, that in itself is good to say, I ran into a set of circumstances that...

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