Where in the World is…

You may or may not have noticed that over the past several months I have been somewhat absent from my...

What’s been happening in Wayne’s World

Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...

Enabling "Open Project Folder" for project types that don't support it

One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...

The Hollywood DBA

I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...

SQL Saturday #171 Pittsburgh!

It's official, there's going to be a SQL Saturday in Pittsburgh this year!

The date is October 6th, and the...

Windows Cluster : Understanding the Quorum settings

In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...

Excel 2013 Will Impact BI Users

As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...

Puzzling TVFunctions

I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between...

T-SQL Tuesday #32 – A Life in the Day

It’s T-SQL Tuesday time again, delayed a week this month, so I had  a whole extra week to get ready....

A Trio of EachDB

When administering a larger database environment, sometimes one needs to perform repetitive tasks.  Performing repetitive tasks becomes more and more painful (maybe even demoralizing) with the larger the number...