Index Stats Duplication

I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index.  This kind of behavior...

OPASS is pleased to announce - SQLSaturday #49 - Orlando October 16th. Get it on your calendar now.

SQLSaturday #49 - Orlando is now live on the SQLSaturday web site.  It will be held on October 16th at Seminole...

PASS Summit Content Survey Results

The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their...

Rebuilding the Home Server

My Windows Home Server died a month ago, just as I was getting ready to leave the country. I didn’t...

Results of PASS Summit 2010 Content Survey Released

A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...

SQL Server 2008 R2 reaches RTM

On April 21 Microsoft announced SQL Server 2008 R2 has been released to manufacturing.
The downloads on Technet/MSDN on May 3....

SQLSaturday 31 Chicago: Recap

Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d...

The Knowledge... (quote)

The quote about Knowledge, sure it is Albanian quote:

Learn the Knowledge but you'll never get rewarded by the God(All-llah) until...

What is a Good Way to Quickly Disable SQL Agent Job Schedules?

Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...

2010 Scripting Games

Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...