As I mentioned in an earlier post, I first met Tomislav Piasevoli’s (blog|twitter) in 2008 at the PASS Summit in Seattle, and saw him again most recently again in Seattle at PASS Summit 2011. There I had the pleasure of telling him personally how much I liked his book. There are not many MDX books [...]

An interesting confluence of events this week takes me both back to the past as I ponder the future! What gives? Well, the recent release of Tomislav Piasevoli’s (blog|twitter) new book, MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook, reminded me of my first meeting with him at a PASS Summit event a [...]

This is the fifth and final post for SSAS week at SQL University. If you’re just joining the class, you should review the previous lessons first: Why Do I Need a Cube & How Do I Get Started Dimension Design 101 Cube Construction 101 Cube Enhancements 101 Today, I’ll show you how to secure access [...]

This is the fourth post for SSAS week at SQL University. Here’s the coursework so far: Why Do I Need a Cube & How Do I Get Started Dimension Design 101 Cube Construction 101 In today’s post, I will show how you to correct problems that you discover in dimensions after you deploy the database [...]

This is the third post for SSAS week at SQL University. If you’re just joining the class, refer to Why Do I Need a Cube & How Do I Get Started and Dimension Design 101 to get caught up.  At this point, my expectation is that you have an Analysis Services project with at least [...]