SSAS Processing Mode (Lazy Aggregations)

Processing mode property of a partition/measure group determines how partitions will be available to users.
Processing mode has two possible options.
Regular....

OT: Goodbye Dad

This is a bit of ramble.

At about 2:15AM November 21st, 2011 my dad, Arthur Corbett, went home to be with...

DBA Team Structure – Thoughts From Real Life

I once talked about the DBA team building about 3 years ago, now when I look back, I still believe...

Content Shift, Still SQL, Just More SharePoint

Many of you may have notice that I have been a little inconsistent with my posts lately. It’s been a...

An Informal Compendium of SSAS Errors, Part 6: Common Errors

This is the last in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...

Thank you

I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the...

SSWUG SSIS Expo Slides and Scripts

You can find the slides and scripts from today’s sesson at the SSWUG SSIS Expo, the materials can be downloaded...

What's new for SQL Server 2012 courses from Microsoft

I tuned into the Third Thursday sessions for November and wanted to try boiling down the talks to what I...

Reference Dimensions

A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...

Thank You SQL Saturday 99 Sponsors!

Last Friday, Minnesota had it’s second SQL Saturday event, on a Friday.  Hopefully, those that were able to attend had...