SQLCAT.com consolidated index of Whitepapers

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 http://blogs.msdn.com/b/sqlcat/ 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

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SQLServer2012_MultisiteFailoverCluster%20(2).docx

http://msdn.microsoft.com/en-us/library/hh781257.aspx

http://msdn.microsoft.com/en-us/library/hh923056.aspx

http://msdn.microsoft.com/en-us/library/jj191711

http://msdn.microsoft.com/en-us/library/jj215886.aspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/Technical%20Case%20Study-Backup%20VLDB%20Over%20Network_Final.docx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBMandLogShipping.docx

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

http://msdn.microsoft.com/en-us/library/ee355221.aspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/MSIT_SAP_Data_Tier_HA_DR.docx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/HA_DR_Zero_Data_Loss.docx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/implappfailover.mspx

http://download.microsoft.com/download/5/B/D/5BD13FFA-5E34-4AE1-9AA0-C6E6951B8FC8/SQL%20Server%202008%20R2%20High%20Availability%20Architecture%20White%20Paper.docx

http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQLServer_HADR_QR.docx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/PartialDBAvailability.doc

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/Replication_HADR_CaseStudy.docx



SQL Server Performance

http://msdn.microsoft.com/en-us/library/ee410782.aspx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBSnapshotPerf.docx

https://msdnshared.blob.core.windows.net/media/2017/02/HighPerformanceSQLServerWorkloadsOnHyper-V_Final.docx

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Performance%20Guidance%20for%20SQL%20Server%20in%20Windows%20Azure%20Virtual%20Machines.docx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/loading_bulk_data_partitioned_table.mspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx

http://msdn.microsoft.com/en-us/library/hh372970.aspx

http://download.microsoft.com/download/D/9/4/D948F981-926E-40FA-A026-5BFCF076D9B9/TEMPDB_Capacity_Planning_Index.doc

http://msdn.microsoft.com/en-us/library/dd425070.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

http://msdn.microsoft.com/en-us/library/dd672789.aspx

http://msdn.microsoft.com/en-us/library/dd266396.aspx

http://go.microsoft.com/fwlink/?LinkId=223367

http://go.microsoft.com/fwlink/?LinkId=223366



Service Broker

http://msdn.microsoft.com/en-us/library/dd576261.aspx



Full Text

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx



Analysis Services

http://technet.microsoft.com/en-us/library/ee410017.aspx

http://www.emc.com/collateral/hardware/white-papers/h8129-performance-scaling-sql-wp.pdf

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/scoqryas.mspx

http://www.microsoft.com/downloads/details.aspx?familyid=7ac8e03d-bf1f-4733-93e0-bc0f6e567608&displaylang=en

http://www.microsoft.com/downloads/details.aspx?FamilyID=3be0488d-e7aa-4078-a050-ae39912d2e43&displaylang=en

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/ssas2005perfguide.doc

http://www.microsoft.com/downloads/details.aspx?FamilyID=65df6ebf-9d1c-405f-84b1-08f492af52dd&displaylang=en

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx

http://technet.microsoft.com/en-us/library/ff956108(v=SQL.100).aspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/olapdbpssas2005.mspx

http://download.microsoft.com/download/4/0/1/40119d1a-e5fb-4099-96fb-2706d6e0ed12/PrecisionforSSAS.doc

http://www.microsoft.com/downloads/details.aspx?FamilyID=3494E712-C90B-4A4E-AD45-01009C15C665

http://download.microsoft.com/download/A/5/7/A575AD7C-4172-42D0-8D58-0698D6802F81/SSASReadOnlyDBs.docx

http://msdn.microsoft.com/en-us/library/hh226085.aspx

http://download.microsoft.com/download/6/5/6/6567C845-FC8D-4D62-920F-C027A349C889/SSASPerfGuide2008R2.docx



SQL Server Integration Services

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SQL_Server_Integration_Services_and_StreamInsight_Together.docx

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SSIS%20Hybrid%20and%20Azure.docx

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SSIS%20Operational%20and%20Tuning%20Guide.docx



SQL General Administration

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/Database_Upgrade_to_SQL_Server_2008_Tools_and_Approaches.docx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/dbcc_showcontig_improvements.mspx

http://www.msinfosec.com/

http://msdn.microsoft.com/en-us/library/dd542632.aspx



SQL Server Security and Audit

http://www.microsoft.com/downloads/details.aspx?FamilyId=6E1021DD-65B9-41C2-8385-438028F5ACC2&displaylang=en

http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx



SQL Server Application, Planning and Features

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL_bestpract_MigrationToUnicode.docx

http://www.microsoft.com/downloads/details.aspx?FamilyID=b5bb47a4-5ece-4a2a-a9b5-5435264f627d&DisplayLang=en

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SQLServer_Denali_Spatial.docx

http://technet.microsoft.com/en-us/library/ms345118.aspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/sap_sql2005_best%20practices.doc

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/sql2005dgwhe.mspx

http://download.microsoft.com/download/8/7/1/871AB973-56AA-4A43-A8FB-2BFF5F2FF8D2/SQL_Server_2008_for_Siebel_CRM_Applications.docx

http://download.microsoft.com/download/9/F/4/9F4B4F2B-3853-4AE6-BD80-DF2D37F5C59F/SQL_Server_2008_with_Oracle_Applications.docx

http://msdn.microsoft.com/en-us/library/ee819082.aspx

http://msdn.microsoft.com/en-us/library/dd283095.aspx

http://technet.microsoft.com/en-us/library/cc917672.aspx

http://technet.microsoft.com/en-us/library/dd894051(v=SQL.100).aspx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/FILESTREAM%20Design%20and%20Implementation%20Considerations.docx

http://technet.microsoft.com/en-us/library/dd459178(v=SQL.100).aspx

http://www.bing.com/search?q=%22Microsoft+SQL+Server+2005+Tuning+Tips+for+PeopleSoft8.x%22&qs=n&form=QBRE&pq=%22microsoft+sql+server+2005+tuning+tips+for+peoplesoft8.x%22&sc=0-0&sp=-1&sk=&cvid=6e15f512349843bf96064944d41e3e6d

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL_bestpract_CollationChange.docx

http://download.microsoft.com/download/E/A/B/EAB6BAEA-2DE6-4E21-97D2-E459A91E5DE7/Using%20PowerPivot%20to%20Analyze%20SAP%20Data.docx

http://technet.microsoft.com/en-us/library/ms345117.aspx

http://go.microsoft.com/fwlink/?LinkId=149267

http://download.microsoft.com/download/8/7/1/871AB973-56AA-4A43-A8FB-2BFF5F2FF8D2/SQL_Server_2008_for_Siebel_CRM_Applications.docx

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/Pre-SQLServer2008_NativeDataProviders_and_NewCollations.docx

http://go.microsoft.com/fwlink/?LinkID=184267&clcid=0x409

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/Spatial_Denali_CTP1.docx

http://download.microsoft.com/download/7/A/3/7A3278D7-C660-4DFB-91FD-0414E3E0E022/Onboarding_SQL_Server_Private_Cloud_Environments.docx



SharePoint

http://technet.microsoft.com/en-us/library/cc917680.aspx

http://technet.microsoft.com/en-us/library/dd890507.aspx

http://go.microsoft.com/fwlink/?LinkID=196600

http://download.microsoft.com/download/A/D/6/AD67E0F2-9E55-4E78-9155-E3AD7FF671CA/PowerPivot%20-%20Existing%20Farm%20Installation.docx

http://technet.microsoft.com/en-us/library/ff729693(v=sql.105).aspx

http://download.microsoft.com/download/A/2/E/A2E9C841-28B1-49B5-9046-12B64E704A9B/PowerPivot%20-%20Single%20Server%20Installation.docx

http://download.microsoft.com/download/9/4/8/948776F7-4533-4EB5-A692-77BD0C72A135/PowerPivot%20ClientServer%20Architecture.pdf

http://download.microsoft.com/download/C/8/4/C84E3771-E642-4BC1-9704-5ADAB434C5DD/PowerPivot%20Security%20Architecture.pdf

http://technet.microsoft.com/en-us/library/gg314585(v=office.14).aspx



Reporting Services

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/Analysis%20and%20Reporting%20Services,%20Design%20and%20Implementation%20A%20SQL%20Server%202008%20Technical%20Case%20Study.docx