 |
| Home |
|
| Events |
|
|
| Services |
|
| Resources |
|
| Partners |
|
| Communications |
|
| Contact Us |
|
 |
|
|
|
| General Links |
ÞMicrosoft.com SQL Server 2008 whitepapers
ÞMicrosoft.com SQL Server 2005 whitepapers
ÞSQLCAT (Customer Advisory Team) whitepapers
|
| SQL Server 2008 Whitepapers |
ÞAuditing in SQL Server 2008
ÞData Compression: Strategy, Capacity Planning and Best Practices (tech reviewed by Paul S. Randal of SQLskills.com)
ÞData Loading Performance Guide
ÞDatabase Encryption in SQL Server 2008 Enterprise Edition
ÞFILESTREAM Storage in SQL Server 2008 (written by Paul S. Randal of SQLskills.com)
ÞHigh Availability with SQL Server 2008 (written by Paul S. Randal of SQLskills.com)
ÞPartitioned Table and Index Strategies Using SQL Server 2008
ÞPlan Caching in SQL Server 2008
ÞSQL Server 2008 Failover Clustering
ÞSQL Server Replication: Providing High-Availability Using Database Mirroring (written by Paul S. Randal of SQLskills.com)
ÞStatistics Used by the Query Optimizer in Microsoft SQL Server 2008
ÞTroubleshooting Performance Problems in SQL Server 2008
ÞTuning the Performance of Change Data Capture in SQL Server 2008 (tech reviewed by Paul S. Randal of SQLskills.com)
ÞUsing SQL Server 2008 Extended Events
ÞUsing the Resource Governor
|
| SQL Server 2005 Whitepapers |
ÞAdvantages of a 64-bit Environment
ÞBatch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
ÞComparing Tables Organized with Clustered Indexes versus Heaps
ÞConnectivity and SQL Server 2005 Integration Services (written by Bob Beauchemin of SQLskills.com)
ÞDatabase Administrator’s Guide to SQL Server Database Engine .NET CLR Environment (written by Kimberly L. Tripp of SQLskills.com)
ÞDatabase Engine Tuning Advisor (DTA) in SQL Server 2005
ÞDatabase Mirroring and Log Shipping Working Together
ÞDatabase Mirroring in SQL Server 2005
ÞDatabase Mirroring: Alerting on Database Mirroring Events
ÞDatabase Mirroring: Best Practices and Performance Considerations
ÞDatabase Snapshot Performance Considerations under I/O-Intensive Workloads
ÞDisk Partition Alignment Best Practices for SQL Server
ÞEnterprise Strategy Group Information Security Brief: SQL Server Runs the Security Table
ÞImproving Performance with SQL Server 2005 Indexed Views
ÞImplementing Application Failover with Database Mirroring
ÞOnline Indexing Operations in SQL Server 2005
ÞPartial Database Availability
ÞPartitioned Tables and Indexes in SQL Server 2005 (written by Kimberly L. Tripp of SQLskills.com)
ÞPerformance Tuning Using Waits and Queues
ÞPhysical Database Storage Design
ÞPredeployment I/O Best Practices
ÞReducing Database Size by Using Vardecimal Storage Format
ÞReporting Services: Planning for Scalability and Performance with Reporting Services
ÞScalability: Internals, Troubleshooting, and Best Practices for use of Scaleout Technologies in SQL Server 2005 (written by Bob Beauchemin of SQLskills.com)
ÞScalability: Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005 (written by Bob Beauchemin of SQLskills.com)
ÞScalability: Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies (includes details/comparisons with Oracle RAC)
ÞSODA: How SQL Server 2005 Enables Service Oriented Database Architectures
ÞSODA: Service Oriented Database Architecture: App Server-Lite? (written by David Campbell, Microsoft Technical Fellow)
ÞSQL Server 2005 Failover Clustering White Paper
ÞSQL Server 2005 for Oracle Professionals
ÞSQL Server 2005 Management Tools Overview (written by Kimberly L. Tripp of SQLskills.com)
ÞSQL Server 2005 Security Best Practices - Operational and Administrative Tasks (written by Bob Beauchemin of SQLskills.com)
ÞSQL Server 2005 Security Overview for Database Administrators
ÞSQL Server 2005 Snapshot Isolation (written by Kimberly L. Tripp of SQLskills.com)
ÞSQL Server I/O Basics (SQL Server 2000)
ÞSQL Server I/O Basics, Chapter 2 (SQL Server 2005)
ÞStatistics Used by the Query Optimizer in Microsoft SQL Server 2005
ÞStrategies for Partitioning Relational Data Warehouses in Microsoft SQL Server
ÞTroubleshooting Performance Problems in SQL Server 2005
ÞWorking with Tempdb in SQL Server 2005
ÞXML Indexes in SQL Server 2005 (written by Bob Beauchemin of SQLskills.com)
|
|
|
|
| SQL Server 2000 Whitepapers |
ÞDatabase Architecture: The Storage Engine
ÞImproving Performance with Microsoft SQL Server 2000 Indexed Views
ÞIndex Tuning Wizard for Microsoft SQL Server 2000
ÞMicrosoft SQL Server 2000 Index Defragmentation Best Practices
ÞQuery Recompilation in SQL Server 2000
ÞSQL Server 2000 Incremental Bulk Load Case Study
ÞStatistics Used by the Query Optimizer in Microsoft SQL Server 2000
ÞUsing Partitions in a Microsoft SQL Server 2000 Data Warehouse
|
|
|
|
| Group links, blogs links to links and other useful links to links of links |
ÞWhitepapers on Microsoft.com (many NOT Listed above)
ÞWhitepapers on MSDN - the Developer Center Whitepapers (many NOT Listed above)
ÞWhitepapers on TechNet - SQL Server 2005 Technologies (many NOT Listed above)
Þ"Previous Versions" Page - Information, links and resources related to previous versions of SQL Server (many NOT Listed above)
|
|
|
|
| Important Note |
January 10, 2008: Re-checked all links for validity and added a link to a relatively new whitepaper on Predeployment I/O Best Practices. Paul.
July 19, 2007: Updated the SQL Server 2000 Defrag link as per an email about the change. This is still an EXCELLENT article to read about the effects of fragmentation (and of course, defragmentation :), even if you're solely working with SQL Server 2005. I hope there will be an update for this one at some point! Thanks for reading, kt
March 29, 2007: Added a few more links, fixed a few broken ones (one via a cut/paste error and the other was one I missed). All of this was thanks to comments on my whitepapers blog post here.
ALL of these links were valid on March 26, 2007 and may no longer be valid. If companies (who shall remain nameless :) would stop
breaking links ;), it would make our lives easier (well, at least for finding content :) BUT we're always going to have this issue as it's just the general nature of the web! So, I'm sorry if you hit a link and don't get where you want to go. Use the whitepaper title to search for it and then be sure to let us know if you find it. Regardless, please let us know that the link is broken and we'll try to find the current link for you as well.
Also, if you find a whitepaper not listed (or linked to) OR you think there's a whitepaper that should specifically be called out on this list, please let us know!
You can reach us at info@SQLskills.com and for specific questions: questions@SQLskills.com. Thanks!
|
|
