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

SQLcruise review

The most amazing journey that I have done in the past years was definitely SQLcruise
(see http://www.sqlcruise.com) – a SQL Server
event organized...

I am back

I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...

Some Good SQL-Related YouTube Videos

A brief discussion and links to a series of YouTube videos from Stéphane Faroult.
I’ll continue the discussion of the table...

Tampa SharePoint Saturday 2011

I presented a 75 minute session at Tampa SharePoint Saturday on PowerShell Basics.
The presentation and demo scripts can be found...