Delen via


Tips, Tricks, and General Info on the Msft BI Platform

Ports Used within Microsoft's BI Platform...

Based upon previous efforts, I've been asked what are the ports involved with SQL Server/MOSS,...

Date: 05/07/2010

PivotDigrams in Visio 2007...Who Knew!

Ok...I may be a little late to the game on this one, especially since this has been out for a few...

Date: 02/18/2010

Getting Excel Web Access Errors with SSAS 2008?

If you are having issues getting Analysis Services 2008 data being refreshed through Excel Services,...

Date: 12/15/2009

Setting Report Builder 2.0 as the Default ClickOnce Report Builder Version (Native and MOSS Integrated)

Once you've installed SQL Server 2008's SP1 (download here), I'm sure you'll want to have Report...

Date: 06/18/2009

Constrained Delegation with Kerberos and SSAS Named Instance

If you building an environment with Kerberos Constrained Delegation, and have a named instance of...

Date: 04/03/2009

Implementing SSRS Reports from SharePoint Server 2007 List Data

There are three fundamental methods for implementing reports against SharePoint Server (MOSS) 2007...

Date: 03/26/2009

Error While Creating PPS SP2 Reporting Services 2008 Report...The Fix

While working on a proof this past week, I installed PerformancePoint 2007 SP2...wishing to use it...

Date: 01/24/2009

Running a SSRS Stress Test with One User Account...Think Again!

Ok...so you are thinking about running a stress test against your Reporting Services 2008...

Date: 01/23/2009

Catch the New Microsoft BI TV Ad Yet?

Well...if you haven't, don't worry it's on YouTube. Once you see it, you'll know why I love the ad...

Date: 01/12/2009

Attend the SQL Server Roadshow - Want the PPTs?

Did you attend a SQL Server 2008 Roadshow in your nearest city? If you did, you got to hear about...

Date: 11/11/2008

Demo files Used In My BI Conference Session...

For those that attended my session (Designing Effective Dashboards with Msft BI Platform) at the 2nd...

Date: 10/07/2008

Microsoft BI Conference a Week Away...Come To My Session

Just a friendly reminder that the 2nd Microsoft Business Intelligence Conference is only a week...

Date: 09/28/2008

SQL Server 2008's Report Builder (RC1) Released

For those that were looking for the latest Report Builder tool (for use with SQL Server 2008 RTM),...

Date: 09/28/2008

Nice Dundas Template for Creating Bullet Charts in SSRS

Well...I came across this Dundas Gauge XML Template while researching an installation issue on a...

Date: 08/10/2008

Teradata/SSAS 2005 - Functionality and Performance Testing White Paper Now Available

Expanding upon the previous posts regarding SSAS 2005 functionality and performance testing with TD...

Date: 07/16/2008

Using SAP Data with Microsoft's BI Tools

I often get asked by organizations how they can leverage their SAP "data" investment against the...

Date: 07/08/2008

Effective Dashboard Design Practices

Through conversations with many customers, I’ve been asked either directly or indirectly what makes...

Date: 06/13/2008

Upgrading SQL Server 2000/2005 Databases to SQL Server 2008

Here at the NY Microsoft Technology Center (NY MTC), we recently ran a series of SQL Server...

Date: 05/30/2008

Optimizing File Locations for Analysis Services 2005

The following techniques can help you to optimize the data files and temporary files used during...

Date: 05/09/2008

Analyze DW/DM Performance Activity with Performance Dashboard Reports

Are you a DBA tasked with keeping a SQL Server 2005 based data warehouse/datamart performing...

Date: 05/09/2008

Object Promotion Process for Microsoft BI Objects

With Integration Services, Reporting Services, and Analysis Services, their respective business...

Date: 04/14/2008

Analysis Services 2005 Design Best Practices - Cubes & MDX

Once you have identified potential Analysis Services bottlenecks, and have made the proper...

Date: 04/01/2008

Performance Testing of Teradata v12 with SQL Server 2005 Analysis Services

Ok...here's part two of the Teradata v12 series. The first blog entry was focused on highlighting a...

Date: 03/28/2008

Functionality Testing of Teradata v12 with SQL Server 2005 Analysis Services

This blog will be a two part series…culminating from my recent internal testing of Analysis Services...

Date: 02/26/2008

SQL Server 2008 Resource Governor - Ease Your Typing

Well...this is certainly not a normal post. This is a snippet of code for a SQL Server 2005 lab that...

Date: 02/12/2008

Creating UDM Report Builder Models in SSRS-MOSS Integration Mode

I've seen this question come up on many a proof...and that is how do you generate Report Models off...

Date: 01/31/2008

Implementing Parent-Child Relationships in Report Builder - Well Sort Of...

Ok...everyone should know by now that SQL Server 2005's Report Builder doesn't support parent child...

Date: 01/27/2008

Implementation of Sparkline Type Reports within Reporting Services

As with any dashboard implementation, an intuitive user interface design is desired, thus leveraging...

Date: 01/09/2008

Welcome to my Blog!

Hi There! Glad you made your way to my blog...what you'll get here is some hands-on insight into the...

Date: 01/09/2008