Sometimes people ask me for the slide deck to my PASS presentation . I send out the deck, but there is only one slide in there that is worth anything. This post summarizes the only useful slide in the entire deck. Let’s think about this question – why...

Case sensitive, that is. Last year, Denny Lee posted about PowerPivot’s case insensitivity problem . Tabular models have the same insensitivity problem by default. As I mentioned in my previous post on language and collation settings , when creating a...

Collation and language settings are tricky; so tricky that my two planned blog posts on this topic can only scratch the surface of what goes on under the covers here. This post is a simplified overview of collation and language settings for Denali. In...

When I was at PASS I fielded a bunch of questions about the BI semantic model, multidimensional (OLAP), and tabular (VertiPaq) models. I think there is some confusion about what the BI semantic model, multidimensional, and tabular models actually are...

Hi, today at my PASS session I gave a demo of a DAX Editor. This is a sample written by three testers on the Analysis Services team - Nick Medveditskov, Karen Aleksanyan, and Sergey Volegov. We will making this sample available on CodePlex as soon as...

I am spending the next couple of days getting ready for PASS Summit 2011 . I have a session on Thursday afternoon, 3 PM, on Developing and Managing a Business Intelligence Semantic Model (BISM) in SQL Server Code Name “Denali” Analysis Services . The...

It is possible for the tabular designer to get into an error state. If you try to save the model, you can get this error message: “Unable to save the file Model.bim. Reason: The file cannot be saved because it is marked as readonly.” Most of the time...

Marco Russo has a nice post about the basics of configuring the workspace database server . You can use his post to learn how to set the tabular instance to use for the workspace database server for new and existing projects. However, there’s more to...