|
|
-
|
|
SQL Server 2005 provides the database application programmer with a rich new development platform by hosting the .NET Framework Common Language Runtime environment (CLR). With new capabilities come new roles and responsibilities for the Database Administra...
|
|
-
|
|
With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Wind...
|
|
-
|
|
The recommendations in this white paper provide best practices for processing in Microsoft® SQL Server™ 2005 Analysis Services. These performance optimizations are based on real-world implementations with some of our top customers and partners who use SQL ...
|
|
-
|
|
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...
|
|