Microsoft SQL Server 2000: A Guide to Enhancements and New Features
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.
557 pages
English edition · First published 2002 by Addison-Wesley · ISBN 9780201752830
Readers also shelved
Broken Promises: Caste, Crime and Politics in BiharMrityunjay Sharma
Dating Dr. DilNisha Sharma
Illusions of FireNisha Sharma
The 5 AM Club: Own Your Morning. Elevate Your LifeRobin Sharma
The Everyday Hero Manifesto: Activate Your Positivity, Maximize Your Productivity, Serve the WorldRobin Shilp SharmaBe the first to rate this book
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.