Not a real BI topic, but today I discovered that you CAN NOT install SQL 2000 or MSDE on Windows XP via Remote Desktop. If you do that, setup hangs at a certain point, when it starts to execute some installation script on SQL Server. The MSDE setup display  Read more

After several years of using Analysis Services and SQL Server 2000, today I stumbled in this problem. I have a DISTINCT COUNT measure that have to measure how many different documents are present in a certain aggregation. Sometimes valid cells has no  Read more

I just atteended a session where Ron Talmage showed the new Snapshot Isolation feature of SQL Server 2005. While it can be used to improve scalability of a traditional LOB application, it’s really important to BI applications. Making a long story short,  Read more

Tom Rizzo yesterday at SQL Server Connections announced that Reporting Services SP2 is coming soom and it will bring us a SharePoint WebPart to display reports. Great news.  Read more

Thanks to the SQL Server Data Mining development team, it’s live the www.sqlserverdatamining.com web site. You can browse DM models, read tutorials and download samples. Let’s go and visit the site, there’s no reason to describe it here. One suggestion  Read more

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