SQL SERVER – 2008 – Server Consolidation WhitePaper Download

Server Consolidation with SQL Server 2008 Writer: Martin Ellis Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal Published: March 2009 Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services…
Read More

SQLAuthority News – Latest Interesting Downloads and Articles

White Paper: Precision Considerations for Analysis Services Users This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due…
Read More

SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots

White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services. This architecture provides the following improvements Improves the utilization of disk resources Optimizes cube processing operations Supports dedicated snapshots for specific users at different points…
Read More

SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005

This article focuses on integration techniques specific to Microsoft Office Visio 2007 and Microsoft SQL Server 2005. Using Visio 2007, you can connect Visio shapes to data that was generated outside Visio. A large amount of data can be captured in a SQL Analysis Services database. Being able to analyze…
Read More

SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability

Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here. Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the…
Read More