December 2006 - Posts

• Use of SQL Prompt / SQL Refactor with non-admin user

  If you use SQL Prompt v3 and/or SQL Refactor like me (they are very useful), you will appreciate this hint on how to correctly enable SQL Server Management Studio add-in menus on a non-admin user account. You have to run this command within each non-admin Read More... Posted Tuesday, December 26, 2006 8:06 PM by Marco Russo (SQLBI) | 0 Comments

• Clarification on Non Empty Behavior property in SSAS 2005 SP2

  I just read this updated paper on MDX performance hints. The section Calculation Non Empty Behavior is very interesting because it clarified me some doubt I had using the Non Empty Behavior property for a measure. The lesson I learnt is that it is better Read More... Posted Monday, December 25, 2006 4:51 AM by Marco Russo (SQLBI) | 0 Comments

• Scope of Named Set in MDX

  I recently noted a behavior of named sets (specifically, the resolution order) that can be not so intuitive. When you define a named set on the cube, it has the same behavior of a session-scoped named set (the one you create with CREATE SESSION SET statement Read More... Posted Sunday, December 24, 2006 6:07 AM by Marco Russo (SQLBI) | 0 Comments

• Analysis Services Hardware Tuning

  There is a new paper on project REAL available: this one cover the hardware class tuning for an Analysis Services database of hundreds of Gb. My first impression is good: it is useful to have a reference for benchmark analysis. Read More... Posted Tuesday, December 05, 2006 11:54 PM by Marco Russo (SQLBI) | 0 Comments

• Wrong calculation for unary operator with many-to-many relationships

  I just posted this bug on connect.microsoft.com - there is an issue when you use unary operator in a parent-child dimension combined with a many-to-many relationship. The problem is that the '+' operator on non-leaf nodes seems to not consider the children Read More... Posted Monday, December 04, 2006 8:32 PM by Marco Russo (SQLBI) | 0 Comments

• Exam 70-445 TS: Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance

  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 usual, an exam allows you to Read More... Posted Sunday, December 03, 2006 5:40 AM by Marco Russo (SQLBI) | 0 Comments