Microsoft SQL Server 2000 Resource Kit (Paperback, CD-ROM)

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

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

INDEX