SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time

Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...

Order of a Result Set in SQL

I have seen people build procedures that rely on a result set being returned in a certain order.  This is...

Windows Azure Service Dashboard – Checkout the health of Azure Services

Windows Azure Service Dashboard is an excellent way to know the health/availability of your Windows Azure Services.

You might always want...

Reblog: September 6 to September 12

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Join The SQL Crazy Train

One of the best lines I heard in the past few weeks was “That train has sailed.”  Combine that with a crazy schedule and we now have a SQL...

Join The SQL Crazy Train

One of the best lines I heard in the past few weeks was “That train has sailed.”  Combine that with...

Are Foreign Keys Better Than Indexes?

When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...

Q&A From “5 Ways to Improve Performance through Indexing”

A few weeks back spoke at a Pragmatic WorksTraining on the T’s on indexing that was titled 5 Ways to Improve Performance through...

PASS Summit agenda now published and I’m speaking!

For those of you who may have been living under a rock for the last few years every year PASS...

Improved Customer Support

In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to...