Microsoft SQL Server 2000 Unleashed, 2/e

Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE.

Table of Contents

Introduction.

I. WELCOME TO MICROSOFT SQL SERVER.

  1. The Microsoft SQL Server Environment.
  2. SQL Server 2000 Environments and Editions.
  3. What's New in SQL Server 2000.

II. SQL SERVER TOOLS AND UTILITIES.

  4. SQL Server Enterprise Manager.
  5. SQL Server Command-Line Utilities.
  6. SQL Server Query Analyzer and SQL Debugger.
  7. Using the SQL Server Profiler.

III. SQL SERVER ADMINISTRATION.

  8. Installing and Upgrading SQL Server.
  9. Client Installation and Configuration. 
 10. SQL Server System and Database Administration.
 11. Creating and Managing Databases.
 12. Creating and Managing Tables in SQL Server.
 13. Creating and Managing Indexes.
 14. Implementing Data Integrity.
 15. Security and User Administration.
 16. Database Backup and Restore.
 17. Database Maintenance.
 18. SQL Server Scheduling and Notification.
 19. Managing Linked and Remote Servers.
 20. Importing and Exporting SQL Server Data Using BCP and DTS.
 21. Administering Very Large SQL Server Databases.
 22. Data Replication.
 23. SQL Mail.
 24. SQL Server Clustering.
 25. Defining System Administration and Naming Standards.

IV. TRANSACT-SQL.

 26. Using Transact-SQL in SQL Server 2000.
 27. Creating and Managing Views in SQL Server.
 28. Creating and Managing Stored Procedures in SQL Server.
 29. Creating and Managing Triggers.
 30. User-Defined Functions.
 31. Transaction Management and the Transaction Log.
 32. Distributed Transaction Processing. 

V. SQL SERVER INTERNALS AND PERFORMANCE TUNING.

 33. SQL Server Internals.
 34. Indexes and Performance.
 35. Understanding Query Optimization.
 36. Query Analysis.
 37. Monitoring SQL Server Performance.
 38. Locking and Performance.
 39. Database Design and Performance.
 40. Configuring, Tuning, and Optimizing SQL Server Options.

VI. ADDITIONAL SQL SERVER FEATURES.

 41. Using XML in SQL Server.
 42. Microsoft SQL Server Analysis Services.
 43. Microsoft Transaction Server.
 44. SQL Server Full-Text Search Services.
 45. SQL Server Notification Services.
 46. SQL Server and the Microsoft .NET Framework.
 47. English Query.

Index.