Nice question. However, you can actually run the code without the default on the dateofjoin column and get the exact same result for id 2. The blank space is causing...

Took a bit to think over since there were so many lines of code, but a good question anyways. Thanks!

Nice question about a function that I do not use enough. Thanks for the question!

Nice question. Good discussion as well.

+1 - Only 16% right now.

Nice question and even better discussion. I wasn't aware of the TRY..CATCH limitation on severity either. Thanks for the info Tom!

Excellent. Think you will continue posting your findings or was the blog just for this sprint?

Nice post on SSAS security. That is a part of SSAS (and most products for that matter) that is not reviewed enough in my opinion.

I have used many of...

Nice question. I had never actually used the DEFAULT keyword in an insert statement before or seen it used. I have used default constraints many times but never considered doing...

Simon, I think this post alone has justified my need to go to PASS next year. Like you said, the ability to talk to experts about the challenges you are...

Exactly. We had a hard time selling dashboards to our executives until we decided to just do the work and show them what was possible. Now it is our main...

Thanks for the 2012 question! These functions are similar to ones that QlikView has in their query language for referencing the previous or next row in a set. Very handy....

Now that is a better looking DSV! Star = good, snowflake = bad!

Like you mentioned, MDX is not for the faint of heart. This was a big stumbling point for...

Another good Wrox book that isn't quite as comprehensive or overwhelming as the one that you are using is the "Knight's 24 Hour Business Intelligence Trainer" book by Brian and...

It really started to come together for me when I used my own data too. The data in AW and Contoso is a little too perfect. That data is great...