SQLCAT.com consolidated index of Whitepapers
Published Dec 20 2018 11:35 AM 3,891 Views
First published on MSDN on Sep 05, 2013

Authored by Shep Shepard

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 P...

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Usin...

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Usin...

A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over th...

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 Technic...

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 St...

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 Recommendation...

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 adC...

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 Scala...

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


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 cas...

Version history
Last update:
‎Oct 28 2022 12:58 PM
Updated by: