Category Archives: White Paper

End-User Microsoft BI Tools – Clearing up the confusion

Posted on February 27, 2012 by

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles.  There is a … Continue reading →

Posted in Excel, PerformancePoint, Power View/Project Crescent, PowerPivot, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | Leave a comment

SQL Server Analysis Services Performance Guide published

Posted on October 28, 2011 by

Another must read white-paper: Analysis Services 2008 R2 Performance Guide. This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions.  It applies to SQL Server … Continue reading →

Posted in SQLServerPedia Syndication, SSAS, White Paper | Leave a comment

SQL Server Analysis Services Operations Guide published

Posted on July 6, 2011 by

Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide This white paper describes how you can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, … Continue reading →

Posted in SQLServerPedia Syndication, SSAS, White Paper | Leave a comment

Great white paper: Microsoft EDW Architecture, Guidance and Deployment Best Practices

Posted on June 6, 2011 by

A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices. It’s a must read if you are a data architect, data developer, or DBA involved in an Enterprise Data Warehouse (EDW).  As the paper says, the … Continue reading →

Posted in Data warehouse, SQLServerPedia Syndication, White Paper | Leave a comment