Via MSDN, there’s now a great whitepaper called Performance Tuning of Tabular Models in SSAS 2012 available for your viewing pleasure. There’s a treasure trove of great information in this whitepaper and I highly recommend anyone developing or reporting on Tabular Models to take a look at this whitepaper. So definitely take a moment to … Continue reading Performance Tuning of Tabular Models in SSAS 2012 Whitepaper Now Available
On April 27th next month, SQL Saturday #215 will be here in beautiful, sunny Jacksonville, Florida and none other than yours truly will be speaking, bright and early at 8:30 in the morning! I’ll be presenting MDXplosion! Intro to MDX. The MDX query language is a powerful tool for extracting data from your cube but … Continue reading SQL Saturday Is Coming To Jacksonville, FL and I’m Speaking!
Coming this 2nd day of March, I will be speaking at SQL Saturday #192 in Tampa, Florida! It’s going to be off the chain no doubt, as the kids say. I’ll be presenting my session, MDXplosion! Intro To MDX. The MDX query language is a powerful tool for extracting data from your cube but can … Continue reading I’m Speaking At SQL Saturday 192 In Tampa
With this post I begin a series of blog posts covering one of the most talked about features of SQL Server 2012: Tabular Modeling. Being new to this like most of us are, I hope to learn much about Tabular Modeling as we walk through the basics of building your first Tabular Model. In this … Continue reading Creating Your First Tabular Model (part 1)
Named sets are simply MDX expressions defined with an alias that return a set of members. If you find yourself writing complex MDX expressions to return a set of members often or if you have a commonly used expression, consider creating a named set. This will prevent you from having to duplicate your work. To … Continue reading Creating Named Sets In Your Cube