This is the type of blog posts you write after you spent hours on a stupid issue and you want to remind what’s happened. And may be it will help someone else in the future. Scenario: you have a MOSS…  Read more

Two days ago I did the 70-445 exam in beta (TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance). I cannot talk about the exam content, but I think I can talk about the exam in general. As…  Read more

Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manage missing parameters of a DAX query? I wrote an article in the…  Read more

I recently delivered the online session Create your first SSAS Tabular Model at 24HOP Pass Summit, which recording is now available here. I received many questions and did not have enough time, so I answer now in this blog post.…  Read more

During the last months I’ve seen an increasing adoption of Analysis Services Tabular (and I’m writing a longer article about a particular area of adoption which was probably not expected – more on that in a few weeks). This year…  Read more

If you use Report Builder with Reporting Services, you can use DAX queries even if the editor for Analysis Services provider does not support DAX syntax. In fact, the DMX editor that you can use in Visual Studio editor of…  Read more

Two years ago Microsoft started a certification program called SSAS Maestro, which was intended to be as a step towards a broader certification such as a Microsoft Certified Architect (MCA) or Microsoft Certified Solution Master (MCSM) for Business Intelligence (so…  Read more

There is a new whitepaper from Microsoft, Microsoft BI Authentication and Identity Delegation, which describes all the authentication and delegation scenarios with Microsoft BI technologies: Personal BI Scenarios (Excel) Team BI Scenarios (SharePoint) Corporate BI Scenarios (Reporting Services, Analysis Services)…  Read more

The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE(     ‘Product Subcategory’,     ‘Product Category’[Product Category Name] = @Category ) Depending on the client and on the driver you are using to…  Read more

Last week Microsoft announced a new licensing schema for SQL Server 2012. If you are interested in an extensive discussion of the new licensing scheme, Denny Cherry wrote a great blog post about that. I’d like to comment about the…  Read more