http://www.sqlskills.com/whitepapers.asp
SQL Server 2005 Whitepapers
ÞAdvantages of a 64-bit Environment
ÞBatch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
Þ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 in SQL Server 2005
ÞDatabase Mirroring: Alerting on Database Mirroring Events
ÞDatabase Mirroring: Best Practices and Performance Considerations
ÞEnterprise Strategy Group Information Security Brief: SQL Server Runs the Security Table
ÞHow SQL Server 2005 Enables Service-Oriented Database Architectures
ÞImproving Performance with SQL Server 2005 Indexed Views
ÞOnline Indexing Operations in SQL Server 2005
Þ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
Þ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)
Þ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 I/O Basics, Chapter 2
Þ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
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
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!
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.
No comments:
Post a Comment