The Nine SQL Server Careers

Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post...

Two simple commands that can be a big help in performance tuning.

The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...

Upcoming Events

My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve...

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be...

Better Presentations–Hide those Windows

This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL...

Business Intelligence Strategy – Beginning Steps

Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...

Last Weeks Top “Reading” Links #99

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now.

If one instance in a multiserver query presents an...

Parameterization Part 3: Parameter Sniffing

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a...

September 2014 – SQL Server Monthly Maintenance Checklist

image source
It’s time for a monthly reminder to review you SQL Server environment.  As with anything, just because it appears...