June 2011 - Posts

• #MDX in London and speculation about future books

  Chris Webb, who wrote the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book with me and Alberto , is preparing another Introduction to MDX course in London, this time from October 26th to 28th. It is now a three day course Read More... Posted Wednesday, June 29, 2011 11:42 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Book, MDX

• IF and IIF statement in #mdx

  Jeffrey Wang wrote an interesting post about internals of IF statement in MDX script , describing how and when it is rewritten as a IIF statement. The interesting news in his post is also a possible query plan tool for MDX in the future. Probably not Read More... Posted Tuesday, June 28, 2011 11:37 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX

• Expert Cube Development book finally on Kindle!

  The book Expert Cube Development with Microsoft SQL Server 2008 Analysis Services is finally available on Kindle ! I received many requests for that and the last one just a couple of days ago from Greg Low in its useful review . I'm curious to see whether Read More... Posted Friday, June 24, 2011 12:15 AM by Marco Russo (SQLBI) | 9 Comments Filed under: Analysis Services, Book

• Strange date relationships with #PowerPivot

  A reader of my PowerPivot book highlighted a strange behavior of the relationship between a datetime column and a Calendar table. Long story short: it seems that PowerPivot automatically round the date to the “neareast day”, but instead of simply removing Read More... Posted Tuesday, June 14, 2011 3:28 PM by Marco Russo (SQLBI) | 2 Comments Filed under: PowerPivot

• Windows Azure Step-by-Step

  My colleague and friend Roberto Brunetti wrote Windows Azure Step by Step Microsoft Press. It is a good introductive book about programming on Windows Azure. He is a well known speaker, author and trainer in Italy and he finally used its great skills Read More... Posted Wednesday, June 08, 2011 11:26 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Book, PowePivot

• Analysis Services Operations Guide white paper available

  Microsoft released the SQL Server 2008 R2 Analysis Services Operations Guide , a white paper that describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server Read More... Posted Thursday, June 02, 2011 9:23 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, SSAS