October 2011 - Posts

• #ssasHelp hashtag for questions about #ssas on Twitter

  As you may have noted, I started using hashtag in titles of my blog posts. The reason is pretty simple: every post is automatically twitted through my account ( @marcorus ) and in this way they can be easily reached also by people monitoring particular Read More... Posted Thursday, October 20, 2011 11:37 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS

• Many-to-many in #BISM Tabular issue in #crescent and #powerview

  If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you: it appears Read More... Posted Tuesday, October 18, 2011 8:06 PM by Marco Russo (SQLBI) | 2 Comments Filed under: BISM, Power View, PowerPivot

• SQL Server Training – from Seattle to London (#sqlpass #sqlserver)

  I’ve been at SQL Pass and it has been a really great conference. I will write soon more technical content, there are a few notes about the good and the bad of the overall experience that I’d like to share. The keynote of David J. Dewitt has been great. Read More... Posted Monday, October 17, 2011 8:12 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SQL Server 2008

• #SSAS 2008 R2 Performance Guide

  Thomas Kejser and Denny Lee released the new Analysis Services 2008 R2 Performance Guide . This is an absolutely must read for any SSAS developer. Remember that many of the optimizations are obtained by doing a proper cube design. Thus, the paper has Read More... Posted Tuesday, October 11, 2011 7:24 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, SSAS

• The ultimate Calendar table for #powerpivot (and #ssas, why not)

  Boyan Penev announced the availability of DateStream project on CodePlex: it is a data feed that can be consumed by PowerPivot but also to generate a calendar table for any type of usage. Yes, Analysis Services has a wizard, but when you are in a hurry Read More... Posted Monday, October 10, 2011 3:09 PM by Marco Russo (SQLBI) | 6 Comments Filed under: Analysis Services, PowerPivot, SSAS

• After #SQLBits ready for #SQLPASS

  I just returned from my second SQLBits , this time in Liverpool, and I have to say it is a really great conference. Everything can be improved, but I have to say that it’s hard to find a conference where you can have more networking opportunities than Read More... Posted Wednesday, October 05, 2011 8:50 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, Conference Communities