Query Performance Tuning in SQL Server

I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...

SSRS report rendered in EXCELOPENXML then something went missing

Recently I had been requested by a client to look into one of their SSRS reports issues. They had one...

The Murder Train is making a stop in Salt Lake City

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...

UNION vs UNION ALL

You might be wondering why I’m going into such a simple subject. Well the way I see it there are...

What will you see at SQL in the City

London, Oct 24, 2014
Seattle, Nov 3, 2014
Come join us.

Filed under: Blog Tagged: Humor, syndicated

Beware the defaults! (in windowing functions)

Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...

Can’t Create A Timeline in Excel on Multidimensional Cube

Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting...

Hell No, DMO - DMV is what it shall be!

So, I've finally decided to draw a line in the sand.  I've been doing some writing lately.  The radio silence...

I'm an MVP

Hello Dear Reader!  Two weeks ago I was very honored to be named a Microsoft SQL Server MVP.  Since then...

Lync 2013 Video Issues on Windows 8

Part of the reason I have a blog is to document issues and resolutions I do not want to forget....