First published on MSDN on Sep 05, 2013
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
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 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
Updated Oct 28, 2022
Version 4.0
DataCAT team
Microsoft
Microsoft
