The Microsoft CAT team has released a new whitepaper Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques. “Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to […]
As he posted here, Brian Welcker (Group Program Manager of Reporting Services) is leaving the Reporting Services team and moving to the Microsoft Healthcare Solutions Group. Brian did so much to […]
As you know, business scorecards are the latest BI craze. Nick Barclay was kind enough to send me a copy of his new book Monitoring and Analyzing with Microsoft Office […]
There could be 1001 reasons why IE asks you for credentials when you access a website configured for Windows Authentication and none of them has to do with Reporting Services […]
Here is a useful page from the SQL Server 2008 BOL that summarizes the SSAS performance improvements in Katmai pretty well. It also shows which functions are optimized. For example, […]
In my opinion, the biggest challenge the Microsoft BI initiative faces today is the inadequate support for Analysis Services. The premimum Microsoft reporting tools claim to support SSAS but they […]
The November CTP (CTP5) of SQL Server 2008 is out. Here are the most significant BI-related highlights that caught my attention. Reporting Services The standalone Report Designer has undergone a […]
One new SSRS 2008 feature that international users will undoubtedly appreciate is parameterized parameter prompts. Previously, the parameter prompts were static. In SSRS 2008, you will notice the familiar function […]
An advanced SSAS performance-related feature is Non Empty Behavior (NEB) which has been discussed in many places including this Mosha’s blog. The issue with NEB in SSSAS 2005 is that […]
SQL Server Magazine published the second part of my Protect UDM with Dimension Data Security article in the October issue of the magazine. In this article, I explain how to […]
