SQLCAT.com consolidated index of Whitepapers

Artigo
09/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 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?

Partilhar via

SQLCAT.com consolidated index of Whitepapers

Comments

Recursos adicionais