SQL Server 2005 Whitepapers

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)
• Database Administrator’s Guide to SQL Server Database Engine .NET CLR Environment (written by Kimberly L. Tripp)
• 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)
• 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)
• Scalability: Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005 (written by Bob Beauchemin)
• 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)
• SQL Server 2005 Security Best Practices - Operational and Administrative Tasks (written by Bob Beauchemin)
• SQL Server 2005 Security Overview for Database Administrators
• SQL Server 2005 Snapshot Isolation (written by Kimberly L. Tripp)
• 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)

Regards
Duane Aritonang
www.artduane.com