November 2004 - Posts

• Do NOT install SQL 2000 or MSDE on Windows XP via Remote Desktop

  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... Posted Sunday, November 28, 2004 9:05 PM by Marco Russo (SQLBI) | 1 Comments

• DISTINCT COUNT measures and NULL value

  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... Posted Tuesday, November 16, 2004 4:18 AM by Marco Russo (SQLBI) | 0 Comments

• Snapshot Isolation Level

  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... Posted Tuesday, November 09, 2004 4:47 PM by Marco Russo (SQLBI) | 0 Comments

• Reporting Services and Sharepoint: WebPart coming soon

  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... Posted Tuesday, November 09, 2004 1:52 PM by Marco Russo (SQLBI) | 0 Comments