Microsoft SQL Server 2000 Resource Kit
This essential kit is packed full of technical details, tools, and utilities to help you maximize the productivity of your enterprise systems, create efficient database applications, and tune the performance of your servers and databases.
Microsoft SQL Server 2000 Resource Kit CD
About the Authors
Part 1 - Introducing SQL Server 2000 and this Resource Kit
Chapter 1 - Introducing the SQL Server 2000 Resource Kit
Chapter 2 - New Features in SQL Server 2000
Part 2 - Planning
Chapter 3 - Choosing an Edition of SQL Server 2000
Chapter 4 - Choosing How to License SQL Server
Chapter 5 - Migrating Access 2000 Databases to SQL Server 2000
Chapter 6 - Migrating Sybase Databases to SQL Server 2000
Chapter 7 - Migrating Oracle Databases to SQL Server 2000
Part 3 - Database Administration
Chapter 8 - Managing Database Change
Chapter 9 - Storage Engine Enhancements
Chapter 10 - Implementing Security
Chapter 11 - Using BLOBs
Part 4 - Availability
Chapter 12 - Failover Clustering
Chapter 13 - Log Shipping
Chapter 14 - Data Center Availability: Facilities, Staffing, and Operations
Chapter 15 - High Availability Options
Chapter 16 - Five Nines: The Ultimate in High Availability
Part 5 - Data Warehousing
Chapter 17 - Data Warehouse Design Considerations
Chapter 18 - Using Partitions in a SQL Server 2000 Data Warehouse
Chapter 19 - Data Extraction, Transformation, and Loading Techniques
Chapter 20 - RDBMS Performance Tuning Guide for Data Warehousing
Chapter 21 - Monitoring the DTS Multiphase Data Pump in Visual Basic
Part 6 - Analysis Services
Chapter 22 - Cubes in the Real World
Chapter 23 - Business Case Solutions Using MDX
Chapter 24 - Effective Strategies for Data Mining
Chapter 25 - Getting Data to the Client
Chapter 26 - Performance Tuning Analysis Services
Part 7 - Digital Dashboards
Chapter 27 - Creating an Interactive Digital Dashboard
Chapter 28 - A Digital Dashboard Browser for Analysis Services Meta Data
Part 8 - Replication
Chapter 29 - Common Questions in Replication
Chapter 30 - Creating Merge Replication Custom Conflict Resolvers Using Visual Basic
Part 9 - Web Programming
Chapter 31 - Exposing SQL Server Data to the Web with XML
Chapter 32 - English Query Best Practices
Part 10 - Designing for Performance and Scalability
Chapter 33 - The Data Tier: An Approach to Database Optimization
Chapter 34 - Identifying Common Administrative Issues
Chapter 35 - Using Visual Basic to Remotely Manage SQL Server 2000
Chapter 36 - Using Views with a View on Performance
Chapter 37 - Extending Triggers with INSTEAD OF
Chapter 38 - Scaling Out on SQL Server