Microsoft SQL Server 2000: A Guide to Enhancements and New Features
by Rahul SharmaView All Available Formats & Editions
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/b>/i>… See more details below
Overview
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 scriptsand 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.
Editorial Reviews
Product Details
- ISBN-13:
- 9780201752830
- Publisher:
- Pearson Education
- Publication date:
- 03/01/1902
- Edition description:
- BK&CD-ROM
- Pages:
- 592
- Product dimensions:
- 7.36(w) x 9.18(h) x 1.13(d)
Read an Excerpt
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, settings, and hardware) for improving the performance of SQL Server applications.
- Provide SQL Server developers and DBAs with scripts and utilities that ease their day-to-day administration jobs.
- Provide a consolidated list comparing features of Oracle 9i and SQL Server 2000 and provide examples of what users should look out for when they start converting their Oracle database to SQL Server.
- Provide information about SQL Server.NET and how SQL Server 2000 fits into the .NET environment.
You, the readers, will have to judge for yourselves whether I have met these goals have been met or not. Regardless of the degree of success, my hope is that at least the effort that went into writing this book will be eviillustrate the command parameters (as for the Index Tuning Wizard--itwiz.exe) and describe what the command line parameters are, it may seem like a rehash of SQL Server Books Online (BOL). This is because the commands are exactly the same, and there can be no better description than BOL for what those command line parameters stand for. They are included only if necessary to illustrate a particular command functionality. All credit for these descriptions of command parameters goes to the BOL team at Microsoft.
Short Outline of the Book
The book is divided into five parts that contain 28 chapters.
Chapter 1: Overview of SQL Server 2000 and what it has to offer in the world of OLTP (online transaction processing) and OLAP (online analytical processing). The SQL Server install, different editions and their feature set differences, upgrading from the previous version to SQL Server 2000 and between different editions, multiple instances, and how to debug SQL Server install are also covered in this part. It also contains a checklist for checking the database server's stability from time to time.
Part I: New Features and Improvements over SQL Server 7.0: Listing and brief description of the enhancements and the new features of SQL Server 2000. Chapters 2-19 cover SQL Server 7.0 (in brief) and what is replaced/added in SQL Server 2000 (in detail, along with examples). Emphasis is on XML and why/how SQL Server 2000 is a Web-enabled database server, how data can be retrieved/added/modified through XML, SQL 2000's tight integration with the Internet, and other new features such as indexed views, DPVs (distributed partitioned views), UDFs (user-defined functions), debugger, and so on.
Part II: Advanced DBA Topics: Chapters 20-24 cover some advanced DBA topics such as using the object models of SQL-DMO to write effective programs, DBCC (database consistency checks) commands and performance optimization and debugging techniques. Orphaned sessions and MSDE are discussed. The installation and bug fixes in SQL Server 2000 Service Pack 1 are also discussed.
Part III: Comparison with Oracle 9i: Since Oracle is the biggest competitor of SQL Server 2000 and since many companies that use Oracle are either shifting to SQL Server 2000 (because it's economically viable) or are planning to support SQL Server 2000 as well in order to broaden their customer base, it is necessary to know the differences between the two and how one can convert applications from Oracle to SQL Server and what it takes from the database perspective to do so.
SQL Server basics are also discussed, as this part is oriented toward people who know Oracle and are interested in migrating their applications to SQL Server 2000. The basics will also be beneficial for novice users of SQL Server 2000.
Part IV: Scripts and Utilities: Chapter 27 contains scripts and utilities to make the day-to-day task of database administration easy. All the scripts are explained and are included on the CD-ROM as well.
Part V: SQL Server.NET: .NET is the latest buzzword in the Microsoft arena. In Chapter 28 we take a look at how SQL Server 2000 fits into the .NET scenario and what can be expected in the next release of SQL Server, code named "Yukon."
Customer Reviews
Average Review: