in

Prologika Forums

Business Intelligence to the Masses

This Blog

Syndication

News

Visit prologika.com for information about Teo's publications, the latest on the Microsoft Business Intelligence initiative, and more...

Prologika (Teo Lachev's Weblog)

Teo Lachev is a consultant, mentor, and author focusing on the design and development of Microsoft .NET business intelligence solutions. Read about Teo's work and life. Registered users can post comments.

February 2007 - Posts

  • Dundas Chart for SharePoint

    Dundas is currently developing a Dundas Chart for SharePoint 3.0/MOSS 2007 (currently in Beta). The chart is designed to work in ASP.NET and supports binding to ADO.NET datasets. A step-by-step tutorial for configuring the chart can be found here.

  • Black Preview

    An unfortunate bug that was discovered late in the SQL Server 2005 SP2 design cycle may cause a black report preview in the ReportViewer Windows Form control (see attached file) with some video cards. The RS team is aware of this and they are working on a hotfix. I am partly to blame for this issue (Tongue Tied) because I've noticed it since the early builds of SP2 but it never occurred to me that it could be a bug. I thought that it could be cause by remoting it to my desktop (sometimes after logging in locally to your desktop after a remote session the colors tend to appear funny).

    It is important to note that this issue only happens in Print Preview mode (normal preview and Report Host (F5) are unaffected). If you don't like the new black preview look and feel please contact Microsoft Product Support for a hotfix when it becomes available. Meanwhile, as a workaround, you should be able to avoid the black preview by setting the background to any other color than trasparent (default background color).

  • SQL Server 2005 Service Pack 2 is Born

    As an update to my previous post, SQL Server 2005 SP2 is now officially available. The SP2 build is 9.00.3042. A SP2 landing page is available too that includes links to the SP2 release, KB articles, marketing information about the benefits of SP2.

    As a personal contributor to Service Pack 2 (mainly in the areas of Reporting Services SharePoint integration and Analysis Services), I hope you enjoy it!

  • SQL Server 2005 Service Pack 2 Is Semi-born

    Thanks for Russell Christopher's blog, we now know that the final release of SQL Server 2005 Service Pack 2 is very close to going live. I will update this blog when the download link is known. I listed the SP2 major BI-related enhancements in this blog. The most significant ones (RS-SharePoint integration, enhanced Excel OLAP and data mining features) makes SP2 a major milestone in the Microsoft Business Intelligence roadmap.

    Posted Feb 19 2007, 09:35 AM by tlachev with 1 comment(s)
    Filed under:
  • Presenting SharePoint-SSRS Integration

    It's time for my annual presentation for the Atlanta.MDF group. This time, the topic will be the SSRS-SharePoint integration mode with SQL Server 2005 Service Pack 2 which I blogged about before. I've uploaded the PowerPoint slides to my website.

  • Feedback on Analysis Services Performance Guide

    Now that I've read the Analysis Services Performance Guide (or shall we call it a mini-book) which I announced in my previous blog, I found it to be a great read. I'd recommend it to anyone who would like to get more insights not only about performance tuning UDM but also about the inner workings of the server.

    Some caveats… The guide doesn't answer the perennial and fundamental question about partitioning a large UDM. As I explained in my UDM Data Islands blog, Microsoft scaled down from the initial "super cube" approach and now advocates splitting a large cube into smaller subcubes (which Jamie McClellan referred to as "data islands") for performance reasons. What I was hoping to find is some performance guidelines and metrics about at what data loads should this split occur. Since this is so important from a performance standpoint, I failed to understand also why there is no reference to linked measure groups and dimensions whatsoever.

    Finally, the guide is a bit light from a capacity planning and load-balancing standpoint. Hopefully, there will soon a refresh of the "Creating Large-Scale, Highly Available OLAP Sites: A Step-by-Step Guide" whitepaper.

Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems