Designing SQL Server 2000 Databases for .NET Enterprise Servers

SQL Server 2000 belongs to an earlier chapter of enterprise computing, but its design choices still matter to anyone maintaining legacy databases or studying how Microsoft’-era server architecture took shape. This guide follows the work from installation and database design through the administration, integration, and performance concerns of a deployed SQL Server system.

From database foundations to enterprise operation

Robert Patton and Jennifer Ogle’s book begins with SQL Server 2000’s capabilities and migration considerations, then moves into installation, configuration, database architecture, and modeling. The progression connects foundational design decisions with the realities of operating a database in a larger environment.

Administration, protection, and availability

Dedicated chapters cover scalability, availability, security, Windows 2000 Active Directory integration, and database maintenance. Backup and recovery receive their own detailed treatment, including planning, backup and restore procedures, and testing recovery strategies—an essential operational discipline, not just a last-minute task.

Working with data across systems

The guide also explores importing and exporting data, Data Transformation Services, replication, and SQL Server’s XML capabilities. Separate coverage of Analysis Services includes online analytical processing and data mining, while another chapter addresses English Query and full-text search.

A reference for the SQL Server 2000 era

Programming tools, Transact-SQL, data-access technologies, and performance-tuning methods round out the 14-chapter scope. The book is best suited to readers investigating or supporting SQL Server 2000 systems, and to technology historians who want a detailed view of enterprise database practice at the start of period. Its guidance is tied to the software version it covers, so it should not be mistaken for documentation for current SQL Server releases.