While I’m testing Analysis Services 2005, I’m starting to think about when and how to use the proactive cache feature vs. using the DTS to insert data straight into a MOLAP partition (using the Dimension and Partition Processing Data Flow items). In both  Read more

You know, I’d like to talk about technical issues more than anything else. But who works with BI and MS technologies know that MS offers you a good server (AS2000, that will be great with AS2005) but a poor client experience: if you put toghether Excel  Read more

SQL Server 2005 has a new version of Analysis Services with a lot of new features, so much that a whole (thick) book would be necessary to describe everything. Nevertheless, many improvements are “marginal”, in the sense that bring us better productivity  Read more

Hi! I’m Marco Russo and I’m a consultant (and also trainer, speaker, writer…) based in Italy. I already have an italian blog ( http://blogs.devleap.com/marco ) but this one is in english and it’s completely dedicated to the world of Business Intelligence  Read more