July 2008 - Posts

• It's not a bug, it's by (bad?) design

  <rant mode="funny"> Most of the time I submitted an issue to Microsoft Connect, I got a "it's by design" answer. I've been always irritated by this sentence because they don't admit in this way that they have a bug. Today, I understood I'm wrong. Read More... Posted Monday, July 28, 2008 8:27 PM by Marco Russo (SQLBI) | 5 Comments

• Microsoft client and server strategies about BI

  The last news is the acquisition of DATAllegro by Microsoft . From a server point of view, Microsoft is doing well (even if not fast as I'd like). But is on the client side that I (and many other customers) are disappointed. I totally agree with the post Read More... Posted Saturday, July 26, 2008 12:14 PM by Marco Russo (SQLBI) | 3 Comments

• The adoption of LINQ

  Eric White has written an interesting post titled "Are developers using LINQ?" - there are interesting considerations about the adoption of functional programming too, but the most interesting part for me is the list of comment of the post. A lot of people Read More... Posted Friday, July 25, 2008 10:57 AM by Marco Russo (SQLBI) | 0 Comments

• SQLBits in UK

  I would like to attend to SQLBits this year, but my agenda is already overbooked. I hope you have the time to attend because there are a lot of interesting sessions , it's a good excuse to visit London (the conference is scheduled on September 13, 2008 Read More... Posted Thursday, July 24, 2008 1:12 AM by Marco Russo (SQLBI) | 2 Comments Filed under: Conference

• MDX best practices analysis using MDX Studio

  Mosha released a new version of MDX Studio (0.4) , which offers an "MDX Analysis" function that suggest best practices for a given MDX query. I tried the tool with some MDX query and it offers very good suggestion (when possible with link to further information Read More... Posted Sunday, July 20, 2008 1:19 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Analysis Services, MDX

• CREATE GLOBAL CUBE statement does not support cascading M2M relationships?

  Thanks to a comment sent by a reader of my M2M paper , I just found a possible bug (or " not supported by design feature") of the CREATE LOCAL CUBE mdx statement. In short, it seems that a simple many-to-many dimension relationship is supported, but if Read More... Posted Tuesday, July 01, 2008 6:57 PM by Marco Russo (SQLBI) | 0 Comments Filed under: M2M, SSAS, CREATE GLOBAL CUBE