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

Database Documentation with a Data Dictionary Part 2

A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing...

Moving On To New Challenges

After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara,...