SQL Server 2000 The Complete Reference

The ultimate resource on Microsoft's reliable database and analysis system Build and manage highly available distributed database applications using SQL Server 2000 and the comprehensive information in this volume. You'll get full details on SQL Server 2000 system and platform architecture, administration, application development, and enterprise services. Learn to program SQL Server with Transact-SQL, handle multi-dimensional data processing with the Analysis Services, use Data Transformation Services, implement data mining and data warehousing techniques, back up and restore databases, and manage security, performance, and more. Complete with real-world examples, SQL Server 2000: The Complete Reference is an invaluable tool for DBAs, operators, developers, and network administrators of all skill levels. BULL; BULL;Install, configure, and administer SQL Server 2000 BULL;Build and deploy Web-enabled, scalable, e-commerce database solutions with XML support BULL;Use permissions, logins, user accounts, and roles to secure databases and servers BULL;Write and deploy T-SQL scripts, stored procedures, triggers, and queries BULL;Take full advantage of the new English Query platform Populate, maintain, and analyze data warehouses and data marts BULL;Plan and set up replication and distributed transactions with Data Transformation Services (DTS) BULL;Build and manage OLAP cubes and systems BULL;Manage multiple, isolated installations of SQL Server from a single machine BULL;Configure fail-over clustering and implement sound disaster recovery proceduresShapiro, Jeffrey is the author of 'SQL Server 2000 The Complete Reference', published 2000 under ISBN 9780072125887 and ISBN 0072125888.