Insufficient Space to Create Databases For SCOM 2012 R2

Ran into a minor issue while installing SCOM. The wizard wants to create two databases. The first requires a minimum...

Learning Options in Seattle Next Month

The 2014 PASS Summit takes place next month. Actually a few weeks, on Nov 3-7, 2014 in Seattle. While many...

Notes From The October 15, 2014 oPASS & MagicPASS Meeting (The Souza-Thon!)

Both groups met at a special joint meeting last night at Nova University, part of Operation Souza. Before I go...

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