SQL Server 2000 : The Complete Reference

by SHAPIRO

• ISBN13: 9780072125887
• ISBN10: 0072125888
• Edition: 1st
• Format: Paperback
• Copyright: 2000-12-08
• Publisher: McGraw-Hill Osborne Media

Summary

Master the revolutionary new release of Microsoft's high-performance, scalable database management system. This complete reference explains installation, configuration, administration, replication, security, backup, and recovery. You'll also learn to exploit all the advanced features of SQL Server 2000, including the Enterprise Manager, TSQL, data warehousing, and OLAP services.

Author Biography

Jeffrey Shapiro (Boca Raton, FL) has been involved in IT for more than 12 years and has worked with hundreds of companies around the world including Microsoft, IBM and Novell. He has been a key speaker on IT and Software Engineering at numerous conferences. Trained as a journalist, Jeffrey now spends most of his time writing on IT. He is also the editor of two new newsletters: Service Level and CRM Review.

Table of Contents

Part I: SQL Server 2000 System and Platform Architecture.

Chapter 1: Getting to Know SQL Server 2000.

Chapter 2: Database Architecture.

Chapter 3: SQL Server 2000 Client/Server Architecture.

Chapter 4: DBMS Architecure.

Chapter 5: Meta Data Services.

Chapter 6: Installing SQL Server 2000.

Part II: SQL Server 2000 Platform Adminstration.

Chapter 7: Adminstering Architecture.

Chapter 8: SQL Server Security and Access Control.

Chapter 9: SQL Server Disaster Recovery.

Chapter 10: SQL Server Replication.

Chapter 11: SQL Server 2000 Databases.

Chapter 12: Administering SQL Server 2000.

Chapter 13: SQL Server 2000 high Availability.

Part III: Programming SQL Server 2000.

Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models.

Chapter 15: Getting Started with SQL Query Analyzer.

Chapter 16: Transact-SQL Primer.

Chapter 17: SQL Server Integrity Programming and Management.

Chapter 18: Stored Procedures and Triggers.

Chapter 19: Query Fundamentals and Strategy.

Chapter 20: Working with Operational Data.

Chapter 21: SQL Server 2000 Advanced Concepts.

Chapter 22: English Query.

Chapter 23: SQL Server and the Internet.

Part IV: SQL Server 2000 Analysis Services.

Chapter 24: Data Mining and Data Warehousing.

Chapter 25: Getting Started: Analysis Services and OLAP.