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

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

Database Owner - Error Message

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

You...

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

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

SQL Dream Cars

A mini debate on Twitter the other day got me thinking about cars. People that know me know I like...