Home Remote DBA Service Consulting and Performance Server Health Checks Training Resources Calendar What our Customers say What our Students say About SQLskills.com		General Links ÞMicrosoft.com SQL Server 2008 whitepapers ÞMicrosoft.com SQL Server 2005 whitepapers ÞSQLCAT (Customer Advisory Team) whitepapers ÞPerformance Tuning Using Waits and Queues ÞDiagnosing and Resolving Latch Contention on SQL Server (tech reviewed by Paul S. Randal of SQLskills.com) ÞDiagnosing and Resolving Spinlock Contention on SQL Server (tech reviewed by Paul S. Randal of SQLskills.com) 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) ÞImproving Performance with SQL Server 2008 Indexed Views ÞPartitioned Table and Index Strategies Using SQL Server 2008 ÞPlan Caching in SQL Server 2008 ÞProven SQL Server Architectures for High Availability and Disaster Recovery (written by Paul S. Randal of SQLskills.com) ÞSQL Server 2008 Failover Clustering ÞSQL Server 2008 Policy-Based Management ÞSQL Server 2008 R2 Security Best Practices - Operational and Administrative Tasks Þ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) ÞUnderstanding and Controlling Parallel Query Processing in SQL Server ÞUnderstanding and Using PowerShell Support in SQL Server 2008 ÞUsing SQL Server 2008 Extended Events (written by Jonathan Kehayias of SQLskills.com) Þ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 Þ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 (reviewed by Paul S. Randal of SQLskills.com) ÞPredeployment I/O Best Practices ÞProven SQL Server Architectures for High Availability and Disaster Recovery (written by Paul S. Randal of SQLskills.com) Þ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 Important Note November 9, 2010: Re-checked all links for validity and fixed broken ones. Paul. 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.
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com