PowerPivot Saga: Scheduled Refresh more than once a day

PowerPivot data models in Excel is a great way to quickly pull data from various sources, build relationship between different...

How I Got Here: 5 Years At Pragmatic Works

I recently celebrated my 5 year anniversary at Pragmatic Works. Boy, how time flies by. It feels like just the...

Unit tests help document your code!

I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for his Google Hangouts series, catch the video here
One of...

Unit tests help document your code!

I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...

Unit tests help document your code!

I recently had the chance honour to spend twenty minutes talking to Boris Hristov about testing with Sql Server for...

PASS Summit 2014 Diary – Day 0

This week, I’m attending two different summit events in the Seattle area.  On Sunday through Tuesday, I’ll be participating in...

Bon Voyage fellow PASS Summit 2014 Attendees!

For the first time ever, I will be a PASS Summit Attendee! I’m very excited about going and I’ll be...

Non use of persisted data – Part Three

A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...

When Things Align Unexpectedly

Reading Time: 4 minutesThings are happening

or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have...

When Things Align Unexpectedly

Things are happening

or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have aligned. I am...