Author Description

From the Back Cover Microsoft's SQL Server™ 2000 promises performance, scalability, and speed. Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features shows database administrators and developers how to deliver on these promises. This book illustrates all the significant enhancements and additions in SQL Server 2000 and shows how they can be used most effectively. Readers learn by example how to use security features, replication, backup procedures, and data warehousing and optimization techniques. Beginning with an overview of SQL Server 2000, this book discusses online transaction processing (OLTP) and online analytical processing (OLAP), features a tour of different SQL Server releases, and offers a guide to installation. The author describes and demonstrates the changes since SQL Server 7.0, thoroughly exploring SQL Server 2000's capacity as a Web-enabled database server. Readers are then immersed in advanced database administration topics such as performance optimization and debugging techniques. Microsoft SQL Server™ 2000 also serves as a resource for those new to SQL Server, providing a basic introduction and details about how to make a conversion work, as well as a feature-by-feature comparison to Oracle 9i. Database administrators will find a collection of clearly explained scripts and utilities to simplify day-to-day tasks. This book concludes with a discussion of how SQL Server fits into the.NET environment and what to expect of the next release. Sample code is used extensively to illustrate feature sets and illuminate topics covered. The accompanying CD includes this sample code as well as scripts and utilities. Rahul Sharma also shares his tips for optimizing applications' performance with adjustments to code, settings, and hardware. He alerts readers to common errors and fixes, and provides a checklist to guide readers through the installation and verification of the database server's stability. Rahul has translated his experience into knowledge and ready-to-use tools that database administrators and developers need to realize the many benefits of moving to SQL Server 2000. 0201752832B02212002 Product Description Focusing primarily on the new features of SQL Server 2000, this informative overview draws on real-world examples and situations to demonstrate how to use the security features, replication, backup procedures, data warehousing, and optimization techniques of SQL 2000 and is accompaned by a companion CD-ROM that contains sample code, along with scripts and utilities for day-to-day DBA jobs. Original. (Intermediate) About the Author Rahul Sharma is a senior database administrator for Manhattan Associates, Inc., and a columnist for both Swynk.com and SQLServerCentral.com. He has been working with Microsoft SQL Server since the release of SQL Server 6.5 and is currently working with both SQL Server 2000 and Oracle 9i. He is a Microsoft Certified Professional with more than six years of experience in database administration. 0201752832AB11162001 Excerpt. © Reprinted by permission. All rights reserved. This book is written for SQL Server developers, DBAs, database managers, systems engineers, and business analysts. It does briefly cover the basics of SQL Server in Part IV, where SQL Server 2000 is compared with Oracle 9i, but throughout the book it is assumed that you have some familiarity with database concepts and SQL Server (any version). When I began writing this book, I had these goals in mind: * Cover the new feature sets of SQL Server 2000 and its enhancements over SQL Server 7.0. * Give a checklist of common errors made with SQL Server and point out how to rectify them to make sure that installs and servers are functioning correctly. * Provide sample code wherever possible to illustrate the feature sets and emphasize the points. * Avoid excessive screenshots and other fillers often used in computer books. * Provide tips (on SQL Server code, set