|
|
-
|
|
This white paper describes how application developers can apply query and processing performance-tuning techniques to their SQL Server 2008 Analysis Services OLAP solutions.
Because Microsoft SQL Server Analysis Services query and processing performance...
|
|
-
|
|
Using Kerberos authentication in a SQL Server 2008 Reporting Services service environment provides a mechanism for mutual authentication between client and server before a secure network connection is established. This article describes how to configure an...
|
|
-
|
|
This document focuses on the technical concepts and techniques we used to implement reports with SQL Server 2008 Reporting Services, using an Analysis Services cube as the data source. Providing strong customer service has helped this customer become the ...
|
|
-
|
|
Proper cube design, efficient multidimensional expressions (MDX), and sufficient hardware resources are critical to optimal performance of MDX queries issued against a SQL Server 2005 Analysis Services instance. This article lists the ten most common best ...
|
|
-
|
|
This paper provides the information about the available MDX query troubleshooting tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries There are a variety of...
|
|
-
|
|
This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few...
|
|
-
|
|
This whitepaper provides optimization techniques for Analysis Services Distinct Count. Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with a number of performance challenges. This white pape...
|
|
-
|
|
This article provides common ways to approach master data management so that it has the best chance of being successful. These examples include implementing a departmental solution that spreads across an organization and implementing a global project based...
|
|
-
|
|
This article provides information about the organizational challenges of implementing a master data management solution. Data governance and data stewardship provide a central role in the success of master data management within an organization. The right ...
|
|
-
|
|
This article provides a technology-centric view of master data management concepts, including possible implementation techniques. After reading this paper, information technology professionals should be able to accurately define the master data management ...
|
|