We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     Page 88 of 882 posts
blog post –

BI Portal for SharePoint

A new version of BI Portal Sample is available from Microsoft. It looks good, but I still haven’t tested it. Integrated with SharePoint and Reporting Services. Support of different localizations. It’s not the definitive solution, but may be useful.  Read more

blog post –

Don’t use quote inside comments with Analysis Services 2000

Yesterday I lost at least an hour (but only for a coincidence I haven’t lose more hours) because I came across a bug of Analysis Services 2000. If you put a single quote or a double quote inside a comment, the whole MDX expression is not considered. I  Read more

blog post –

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

blog post –

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

blog post –

SQL Server Data Mining website live!

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

blog post –

Direct MOLAP insert vs. proactive cache

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

blog post –

When marketing is evil

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