Attending the Summit? Learn Networking With Don Gabor!

My friend, author, and networking guru Don Gabor is back at the Summit for the third year in a row,...

Me an MVP? It Really Happened

Yes, I was named a SQL Server MVP the most recent round of awards.  I honestly can’t believe it.  It...

GET MVP DEEP DIVES VOL 2 50% OFF - TODAY ONLY!

Quick blog post to let you know that a special ONE-DAY TODAY ONLY deal by the publisher of the fantastic SQL Server...

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