SQL Saturday 52 Recap

I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver.  This was the...

SQL Server 2008 Service Pack 2 Released

Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack...

Stupid Tech Support Tales

One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log:

"9/22/2010...

When the Bloc Québécois is a Nuisance for Quebeckers’ Interests: The Top 20 Countdown

 The below is a republished version that has been released officially on the Canadian Federal Liberal Party's web site.  Finally...

A Small Selection of SQL Azure System Queries

I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...

Common SQL Server Mistakes – Indexing Every Column

If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...

Don’t Take me (too) Literally

Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...

Grabbing SWAG

It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...

How to Prove a Fact (Again)

Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about...

Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild

Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...