SQL Server 2000: The Complete Reference

SQL Server 2000: The Complete Reference

by Jeffrey R. Shapiro
     
 

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…  See more details below

Overview

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.

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.

  • Install,configure,and administer SQL Server 2000
  • Build and deploy Web-enabled,scalable,e-commerce database solutions with XML support
  • Use permissions,logins,user accounts,and roles to secure databases and servers
  • Write and deploy T-SQL scripts,stored procedures,triggers,and queries
  • Take full advantage of the new English Query platform Populate,maintain,and analyze data warehouses and data marts
  • Plan and set up replication and distributed transactions with Data Transformation Services(DTS)
  • Build and manage OLAP cubes and systems
  • Manage multiple,isolated installations of SQL Server from a single machine
  • Configure fail-over clustering and implement sound disaster recovery procedures

Read More

Editorial Reviews

This reference for database administrators, operators, developers, and network administrators of all skill levels describes the various applications of Microsoft's SQL Server 2000 database management and data analysis system. Topics include, for example, how to build scalable, distributed, Web-enabled database solutions; implementing sound security protocols; and creating and using data warehouses. Coverage extends to special topics such as the Server's support for XML and English Query. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Product Details

ISBN-13:
9780072125887
Publisher:
McGraw-Hill Companies, The
Publication date:
12/01/2000
Series:
Database Professional's Library
Pages:
931
Product dimensions:
7.42(w) x 9.12(h) x 2.08(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >