SQL Server 2000 Resource Kit

This SQL Server Resource Kit is designed for database administrators and developers who already use SQL Server and want some helpful tips, advanced techniques, and useful tools or samples to enhance their work with SQL Server 2000. It is the premier guide for deploying, managing, optimizing, and troubleshooting SQL Server 2000.

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 Revolvers 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

Part 11 – CD-ROM Content

•Chapter 39: Tools, Samples, eBooks, and More
Top of pageTop of page