Pragmatic Works is on YouTube !

I bet you didn’t know Pragmatic Works has our own YouTube channel ? Check it out at

There is some great...

Don’t Miss our Upcoming Webinar Series in February and March

More awesome happenings from Pragmatic Works, Wrox, and SQLServerCentral.com. Check out our Upcoming Webinar Series next week. They are free,...

Using MDX to work with the File System

There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...

Important SSAS Dimension Properties

When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...

Why don’t lookup columns appear in no match output?

I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...

Improve your SSMS Interaction

Ever wanted to liven up your life some with some color in your day to day DBA duties. There are...

LastPeriods and PeriodstoDate

There are several ways for calculating “To-Date” calculations the longer way. These normally include a more granular level of control...

MDX Time Calculation Shortcuts

There are lots of ways to calculate time comparisons in MDX, but there are some great shortcuts. The functions WTD,...

Connecting to DB2 AS\400 with SSIS

We have a lot of projects in our organizations that require us to work with database systems other than SQL...

Carrier Pigeon Beat Local Telcom

It’s not often that we find stories that make us laugh out loud, unless they have to do with situations...