SQL Server 2000 Advanced Administration and Development

Author: FeiSi Technology Product R&D Center
Publisher:
Publish Date: 2002-01-01
Features: This series of books uses Microsoft .NET Enterprise Server products as tools and aims to build the next-generation Internet e-commerce platform. It highlights the architecture and layout of enterprise information systems, as well as the technical features and experience of enterprise management. It provides a detailed introduction on how to use .NET Enterprise Server products to build enterprise information systems and guides the establishment and management of information systems at different levels. This series of books is highly practical, offering numerous case studies to help readers fully master how to use .NET Enterprise Server products to build information systems and solve problems encountered in actual management and development. Building an enterprise information system is a comprehensive systematic project, and any information system requires a database server as its backend to support enterprise information computing. From daily transaction processing to e-commerce applications, from simple transaction databases to data warehouses, and from statistical analysis to analytical services and data mining, all require the construction of an enterprise database server. SQL Server 2000 is a new platform for creating large-scale online transaction processing, data warehouses, and e-commerce. It supports a fully integrated XML environment, new data mining features in analytical services, and enhanced knowledge base technology in metadata services, all while improving stability, scalability, and operational simplicity. The book is divided into three parts. In the Basics section, it primarily introduces some fundamental content of SQL Server 2000, including the installation, startup, and operation of the SQL Server 2000 server, the use of SQL Server Enterprise Manager, the architecture of SQL Server 2000, and how to design enterprise databases. SQL Server provides various management tools to facilitate administrators in performing various management tasks. In the Management section, it primarily introduces how to manage SQL Server servers, which is crucial for both administrators and developers. In the Enterprise Database Application Development section, it primarily introduces how to use SQL Server to develop enterprise applications, business applications, and web applications. In the Data Warehouse section, it primarily introduces how to analyze data in data warehouses, extract useful information from them to support management decisions, which is more important for enterprises than simply browsing simple data. This book is primarily aimed at intermediate to advanced network administrators, network programmers, system analysts, and system integration personnel, and can also be referenced by e-commerce system planners, designers, and maintenance personnel. The book provides a detailed introduction to the management, development, and network applications of the SQL Server 2000 database platform, mainly including: database design; failover clustering; client-server management; enterprise data backup, replication, and recovery; monitoring server performance and activity; DTS services; troubleshooting and security management of SQL Server Enterprise Server; data mining; and building enterprise warehouse analysis systems. The greatest feature of this book is its emphasis on the network functions, data warehouses, data mining, and analytical services of SQL Server 2000, as well as the extensive insights and experience of the authors in database management and development practice. This book is a reference guide for SQL Server 2000 system management and development.