SQLCAT.com consolidated index of Whitepapers

In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking.  Hopefully this will make finding those papers a little easier.

The organization is not quite perfect as many of these papers can cover multiple features and topics, but this is pretty close.  If you happen to find any links that are broken or wrong, please post a comment and we will get it addressed. 

More content will be migrated by the end of month, so stay tuned!

 

SQL Server High Availability Backup Recovery SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network Database Mirroring and Log Shipping Working Together Database Mirroring Best Practices and Performance Considerations High Availability and Disaster Recovery at ServiceU: A SQL Server 2008 Technical Case Study High Availability and Disaster Recovery for Microsoft’s SAP Data Tier: A SQL Server 2008 Technical Case Study Failure Is Not an Option: Zero Data Loss and High Availability Implementing Application Failover with Database Mirroring Proven SQL Server Architectures for High Availability and Disaster Recovery SQL Server 2008 Failover Clustering SQL Server High Availability and Disaster Recovery for SAP Deployment at QR: A Technical Case Study" SQL Server Replication: Providing High Availability using Database Mirroring Partial Database Availability Using Replication for High Availability and Disaster Recovery

 

 SQL Server Performance Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications Predeployment I/O Best Practices SQL Server 2005 Waits and Queues Database Snapshot Performance Considerations under I/O-Intensive Workloads High Performance SQL Server Workloads on Hyper-V Performance Guidance for SQL Server in Windows Azure Virtual Machines Loading Bulk Data into a Partitioned Table Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild The Data Loading Performance Guide 2008 Troubleshooting Performance Problems in SQL Server 2005 Troubleshooting Performance Problems in SQL Server 2008 Tuning the Performance of Change Data Capture in SQL Server 2008 Diagnosing and Resolving Latch Contention on SQL Server Diagnosing and Resolving Spinlock Contention on SQL Server

 

Service Broker Service Broker: Performance and Scalability Techniques

 

Full Text SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

 

Analysis Services Accelerating Microsoft adCenter with Microsoft SQL Server 2008 Analysis Services REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios Scale-Out Querying with Analysis Services Scale-Out Querying with Analysis Services Using SAN Snapshots The Analysis Services 2008 Performance Guide Analysis Services 2005 Performance Guide Analysis Services Distinct Count Optimization Analysis Services Processing Best Practices

Analysis Services ROLAP for SQL Server Data Warehouses Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services OLAP Design Best Practices for Analysis Services 2005 Precision Considerations for Analysis Services Users Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques Scale-Out Querying for Analysis Services with Read-Only Databases SQL Server 2008R2 Analysis Services Operations Guide Analysis Services 2008 R2 Performance Guide

 

SQL Server Integration Services Using SQL Server Integration Services and StreamInsight Together  SSIS Tips Tricks and Best Practices: SSIS for Azure and Hybrid Data Movement SSIS Tips Tricks and Best Practices: SSIS Operational and Tuning Guide

 

SQL General Administration Database Upgrade to SQL Server 2008 Tools and Approaches DBCC SHOWCONTIG Improvements in SQL Server 2005 and comparisons to SQL Server 2000 Disk Partition Alignment Best Practices for SQL Server Enterprise Policy Management Framework with SQL Server 2008

 

SQL Server Security and Audit Reaching Compliance: SQL Server 2008 Compliance Guide Manage Kerberos Authentication Issues in a Reporting Services Environment

 

SQL Server Application, Planning and Features Best Practices for Migrating Non-Unicode Data Types to Unicode Improving Microsoft CRM Performance and Securing Data with SQL Server 2008

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 3 Performance Optimizations for the XML Data Type in SQL Server 2005 SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability SQL Server 2005 Deployment Guidance for Web Hosting Environments SQL Server 2008 with Siebel CRM Applications" SQL Server 2008 with Siebel, PeopleSoft and JD Edwards Applications SQL Server Consolidation Guidance

SQL Server Best Practices – Implementation of Database Object Schemas

ComparingTables Organized with Clustered Indexes versus Heaps

DataCompression: Strategy, Capacity Planning and Best Practices

FILESTREAMDesign and Implementation Considerations

Implementinga SQL Server Fast Track Data Warehouse

MicrosoftSQL Server 2005 Tuning Tips for PeopleSoft8.x  The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode Using SQL Server PowerPivot for Excel to Analyze SAP Data XML Support in Microsoft SQL Server 2005 BizTalk Server 2009 Hyper-V Guide SQL Server 2008 with Siebel CRM Applications Working with the New SQL Server 2008 Collations and Earlier Versions of the Native Data Provider Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 1 Onboarding SQL Server Private Cloud Environment

 

SharePoint Configure a Sharepoint Server Farm for minimal downtime during software updates Configure disaster recovery across SharePoint farms by using SQL Server log shipping Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products PowerPivot for SharePoint - Existing Farm Installation PowerPivot for SharePoint - Transitioning from a Single Server to SharePoint Farm PowerPivot for SharePoint: Single Server Installation PowerPivot Technical Diagram: PowerPivot Client/Server Architecture PowerPivot Technical Diagram: PowerPivot Security Architecture Edgenet Realizes the Power of Dynamic IT and Self-Service BI

  

Reporting Services Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study

Comments

• Anonymous
  October 14, 2013
  what happend to the SSD white paper? formerly: sqlcat.com/.../analysis-services-distinct-count-optimization-using-solid-state-devices.aspx

• Anonymous
  October 31, 2013
  Hello there link to SQL Server 2008 Failover Clustering is broken.

• Anonymous
  May 02, 2014
  @gertc www.microsoft.com/.../details.aspx

• Anonymous
  February 03, 2015
  can anyone find this whitepaper ? analysis services distinct count optimization using solid state devices

• Anonymous
  February 02, 2017
  The comment has been removed

  • Anonymous
    February 02, 2017
    Unfortunately that does seem to be the case! I will attach a local copy of this whitepaper to the post itself.
  • Anonymous
    February 02, 2017
    Fixed now. Thank you for your patience.

• Anonymous
  March 14, 2017
  I can't reach "Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services". Are there any mirrors of the whitepaper?