Book Nook Join Book Nook

Microsoft SQL Server 2000: A Guide to Enhancements and New Features

Rahul Sharma

This is a focused guide to SQL Server 2000 for experienced SQL Server administrators and developers. Rahul Sharma focuses on helping professionals take advantage of the powerful new features built into SQL Server 2000 -- and on providing real-world solutions, scripts, and utilities that can dramatically improve your effectiveness.KEY TOPICS: Sharma begins with an overview of SQL Server 2000 focused on its compelling new features for both OLTP and OLAP applications. He reviews key installation-related issues, including debugging install problems, and configuring multiple instances; and provides an expert checklist for checking your database server's stability. Sharma reviews major enhancements to SQL Server 2000, including XML support, tight Web integration, indexed views, distributed partitioned views, user-defined functions, and more. Next, he moves on to advanced SQL Server 2000 database administration, including the use of SQL-DMO object models, database consistency checks, optimization techniques, and the latest bug fixes. The book includes a detailed comparison with Oracle 9i, as well as specific guidance for database professionals migrating to SQL Server or planning to use both databases in tandem. An extensive library of powerful scripts and utilities for SQL Server administration is presented in the book and on the accompanying CD-ROM. Sharma concludes with a preview of SQL Server.NET, and the evolving role of databases in the .NET era.MARKET: For all SQL Server database administrators, developers, and managers, and for others who depend upon SQL Server databases, including Web and e-Business professionals.

GenresSQL server

557 pages

English edition · First published 2002 by Addison-Wesley · ISBN 9780201752830

Readers also shelved

Be the first to rate this book

Tap or drag across the stars

Keep track of what you read

Book Nook is a free reading tracker with a 3D bookshelf, a reading timer, challenges with friends and a Reading Wrapped at the end of the year. Add Microsoft SQL Server 2000: A Guide to Enhancements and New Features to your shelf in one tap.

Join Book Nook Get the app