Marco Russo's Blog
View full profileFirst steps with #ssas #Tabular in #Denali #CTP3
The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and acronyms Read more
Installing Analysis Services #ssas #Denali CTP3 and #PowerPivot #Denali CTP3
Microsoft released the CTP3 of Microsoft SQL Server Code Name “Denali”, as you can see in the SSAS product group blog post . This is the first public release of Denali and after many months of forced silence (I was under NDA) I can finally write my first Read more
DAX Deep Dive at #sqlbits9
I and Alberto Ferrari will present a DAX Deep Dive training day at SQLBits 9 in Liverpool, on September 29th. The conference will continue on September 30th and October 1st. Registrations are not yet open, but you should definitely save the date for SQLBits! Read more
#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
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
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
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
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
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
#BISM Introduction and #PowerPivot Advanced Data Modeling #sqlbits video available
As Chris announced in his blog, some of the sessions from the SQLBits 8 in Brighton are already available (for free!). Yesterday I watched more than half of my BISM Introduction session just to check that no NDA was broken. And, believe it or not, the Read more