This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View. It will show how Multidimensional models are mapped to Tabular concepts, what works and what doesn't work in DAX, how Power View works with Multidimensional models and what other benefits there are to using DAX with a Multidimensional model.

Dave Morrison will be presenting the following:

Myth Busters! Busting Common TSQL Myths

In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis. We will look at areas such as Indexing / SARGability, joins & sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have.