SQL Server 2000: The Complete Reference (Database Pro library) - Softcover

Shapiro, Jeffrey

Softcover

ISBN 10: 0072125888 ISBN 13: 9780072125887

Publisher: Osborne/McGraw-Hill, 2000

Synopsis

This volume covers basic to advanced topics, including the management and access of distributed data, as well as the creation and management of advanced online analytical processing (OLAP) systems.

About this title

About the Author

Jeffrey Shapiro (Boca Raton, FL) has been involved in IT for more than 12 years and has worked with hundreds of companies around the world including Microsoft, IBM and Novell. He has been a key speaker on IT and Software Engineering at numerous conferences. Trained as a journalist, Jeffrey now spends most of his time writing on IT. He is also the editor of two new newsletters: Service Level and CRM Review.

From the Back Cover

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

Edition details

• Publisher: Osborne/McGraw-Hill
• Publication date: 2000
• ISBN 10: 0072125888
• ISBN 13: 9780072125887
• Binding: Paperback
• Language: English
• Number of pages: 960