Orlando 101 For SQLRally Attendees: Where To Eat

The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...

Orlando 101 For SQLRally Attendees: Accommodations & Travel

The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...

Certifications – and a survey.

G’day,
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them...

I Won't Be at SQL Rally

I am excited about the SQL Rally event that's coming up next week. However, I won't be there. I've been...

A row has no row number

It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s...

My PASS Summit Submissions

Following Andy Leonard's (blog | twitter) footsteps, here are my PASS Summit submissions. I decided to go a little different this...

My Partitioning And Compression Quest! (Continued)

Thank you, David C, for your comment!  Please see below to the answers to
your questions.
The table structure is:
CREATE TABLE...

Outlook Productivity Tricks

I have a love/hate relationship with Outlook. It's the required email client at work and because it interfaces with so...

Policy-Based Management and Local Password Policy

This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...

Designing Reports with Custom MDX Queries – part 2

…continued from part 1:

Building a Report

For the remainder of this article, I will demonstrate query and report design techniques by...