July 2008 - Posts

• SQL PASS Summit 2008 and MS BI Conference 2008

  SQL PASS Summit 2008 and Microsoft Business Intelligence Conference 2008 are two major conferences targeting very similar audiences. And this year both conferences are happening in the same location very close to each other (there is just one month separating Read More... Posted Thursday, July 31, 2008 11:59 PM by mosha | 1 Comments

• Product Volatility: Optimizing MDX with MDX Studio

  In this article we will show how to take typical, everyday MDX and optimize it by simply following advices of MDX Studio Analyzer. As a starting point, I will take “ Product Volatility ” example as published by Thomas Ivarson in his blog. It is a perfect Read More... Posted Tuesday, July 29, 2008 9:38 PM by mosha | (Comments Off) Filed under: mdx, mdx studio, performance

• Microsoft buys DATAllegro

  Official pressrelease: http://www.datallegro.com/pr/7_24_08_microsoft_acquisition.asp Curt Monash coverage: http://www.dbms2.com/category/products-and-vendors/datallegro/ This is a huge win for Microsoft Data Warehousing (and therefore BI) strategy ! Read More... Posted Thursday, July 24, 2008 1:17 PM by mosha | 4 Comments

• Analyze MDX with MDX Studio

  Always adhering to the MDX best practices could be a difficult quest to follow. While there is plenty of information out there, it is scattered across book, whitepapers, blogs, BOL, forum posts etc. And this information could be difficult to digest, and Read More... Posted Sunday, July 13, 2008 10:29 PM by mosha | (Comments Off)

• The simpler MDX is – the better !

  Whenever I am asked “What is the single most important advice to write efficient MDX”, I always give same answer: The simpler MDX you write – typically the better performance you will get. The reasoning behind this is straightforward: If MDX is simple, Read More... Posted Friday, July 04, 2008 8:25 PM by mosha | (Comments Off)

• MDX Studio Online – Format and Parse MDX

  MDX Formatting functionality debuted in MDX Studio 0.2.8, and judging by the amount of feedback I got on it – it became the most popular feature of MDX Studio ever ! Couple of people mentioned that for SQL formatting/beautifying needs, they would go online Read More... Posted Tuesday, July 01, 2008 12:55 AM by mosha | (Comments Off)