Index usage

Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...

TCP Chimney offload

On Windows 2003 Enterprise Edition Service Pack 2 TCP Chimney was enabled by default. It took me a while to...

Backup/Restore vs Detach & Attach

You want to move a database from one server to another. There are two options to do that.

1) Detach/Attach: To...

Attend the PASS Summit from Home, 2011 edition

Hidy-ho there, neighbors! This is an update of last year’s Attend the PASS Summit from Home blog. I’ll be updating this...

SQL Server – Marking a stored procedure as system object

Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...

SQL Bits 9

SQL Bits was great
It’s been two years or more that I’ve been invited to SQL Bits. Not by email, but...

Using Configuration Tables in SSIS 2008/2005

SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...

A "New Guy" Joins Our Team

It's a great day for me and Moulding and Millwork (the company I work for).  A few weeks back, I let you all know that I'd been given the...

A "New Guy" Joins Our Team

It's a great day for me and Moulding and Millwork (the company I work for).  A few weeks back, I let you all know that I'd been given the...

October Monthly SQL Server Checklist

It’s the first Monday of the October and it’s time to do a monthly checkup.  If you are like me,...