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

A Trio of EachDB

When administering a larger database environment, sometimes one needs to perform repetitive tasks.  Performing repetitive tasks becomes more and more...

T-SQL Tuesday: A Day in the Life of a BI Developer

My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles.  I’ve been a BI developer for...