MICROSOFT SQL SERVER 2000: A GUIDE TO ENHANCEMENTS AND NEW FEATURES
Ouvrage 9780201752830 : MICROSOFT SQL SERVER 2000: A GUIDE TO ENHANCEMENTS AND NEW FEATURES
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.
Introductions
This book is written for SQL Server developers, DBAs, database
managers,system engineers and business analysts. It assumes that you
have some familiarity with the database concepts and with SQL Server. It
does cover the basics of SQL Server briefly in Part IV where comparison
of SQL Server 2000 is made with Oracle 9i but throughout the book it is
assumed that you have some familiarity with SQL Server (any version).
When I began writing this book, I had these goals in mind:
* To cover the new feature sets of SQL Server 2000 and to tell the
readers what have been the enhancements over SQL Server 7.0
* To give the readers a checklist and point out the common errors that
user do in SQL Server and how to rectify them to make sure that their
installs and their servers are functioning correctly.
* Provide sample codes wherever possible to illustrate the feature sets
and emphasize the points.
* Avoid excessive screenshots and other fillers that are generally used
in computer books to fill up pages.
* To provide readers tips (both sql server code, settings and hardware
wise) for improving the performance of their SQL Server applications.
* To provide SQL Server Developers and DBAs with scripts and utilities
that would ease their day-to-day administration jobs.
* To provide a consolidated list of feature comparisons between Oracle
9i and SQL Server 2000 and to provide examples of what they should look
out for when they start converting their Oracle database to SQL Server.
* To provide information about SQL Server.NET and how SQL Server 2000
fits into the .NET environment.
I have tried my level best togoals. You, the readers, will have to judge
yourself whether 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 evident.
At times where I had to illustrate the command parameters (like for the
index tuning wizard itwiz.exe ) and some description of 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 other better description than BOL for what those command
line parameters stand for. These have been included only if they are
necessary to illustrate some particular command functionality. All
credit for providing these descriptions for command parameters goes to
the BOL team at Microsoft.
Short Outline of the Book
The book is divided in 7 Parts that contain 29 chapters. A brief
description of what the parts offer:
Part I: Introduction: An 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 previous
version to SQL Server 2000 and between different editions, multiple
instances and how to debug SQL Server install issues are also covered in
this part. It also contains a checklist for checking the database
server's stability from time to time.
Part II: New features and improvements over SQL Server 7.0: A listing
and a brief description of the enhancements and the new features of SQL
Server 2000. These chapters cover what we had in SQL Server 7.0 (in
brief) and what has been 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 can data be retrieved/added/modified
through XML. SQL 2k's tight integration with the Internet and other new
features such as indexed views, DPVs (Distributed Partitioned Views),
UDFs (User Defined Functions), Debugger etc.
Part III: Advanced DBA Topics: This covers 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. The topics of Orphaned Sessions and MSDE are
discussed. The installation and bug fixes in SQL Server 2000 Service
Pack 1 are also discussed.
Part IV: Comparison with Oracle 9i: Since Oracle is the biggest
competitor of SQL Server 2000 and since many companies which are using
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 becomes necessary to know what are the
differences between the two and how one can convert their applications
from Oracle to SQL Server and what it would take from the database
perspective to get this done. SQL Server basics are also discussed as
this section is oriented towards people who know Oracle and are
interested in migrating their applications to SQL Server 2000. This will
hence be beneficial for the novice users of SQL Server as well to know
and learn the basic concepts of SQL Server 2000.
Part V: Scripts and Utilities: This part contains lots of scripts and
utilities to make the day-to- day task of database administration easy.
All the scripts are explained and are included with the CD-ROM as well.
Part VI: SQL Server.NET: .NET is the latest buzzword in the Microsoft
arena. In this part 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".
Part VII: Appendixes. Part A of the appendix gives some useful SQL
Server Resources. Part B of the appendix lists all the contents of the
CD-ROM.
About the Author
Rahul Sharma is working as a Senior Database Administrator for Manhattan
Associates Inc. in Atlanta, GA and has been working with Microsoft SQL
Server since SQL Server 6.5 and is currently working with SQL Server
2000 and Oracle 9i. He has got 5+ years of experience as a Database
administrator and has worked in Sybase 10, Oracle 7.1, 8.1.6 and Oracle
9i and SQL Server 6.5/7.0/2000.
He also writes technical articles related to SQL Server for these two
sites: http://www.swynk.com ( http://www.swynk.com/friends/sharma ) and
http://www.sqlservercentral.com (
http://www.sqlservercentral.com/columnists/rsharma )
Table of Contents
Preface
Acknowledgments
Ch. 1 SQL Server 2000 Overview 1
Pt. I New Features and Improvements over SQL Server 7.0 33
Ch. 2 Enhancements and Changes to Existing Features 35
Ch. 3 XML Support in SQL Server 2000 49
Ch. 4 Engine Enhancements in SQL Server 2000 77
Ch. 5 DTS Enhancements 99
Ch. 6 Profiler and Index-Tuning Wizard Enhancements 113
Ch. 7 Replication Enhancements 145
Ch. 8 New Data Types 155
Ch. 9 User-Defined Functions 161
Ch. 10 Indexed Views 169
Ch. 11 Trigger Alternatives 181
Ch. 12 Meta Data Services Enhancements 191
Ch. 13 Tool Enhancements 199
Ch. 14 Backup and Recovery Enhancements 205
Ch. 15 Analysis Services Enhancements 213
Ch. 16 Distributed Partitioned Views 221
Ch. 17 T-SQL Debugger 235
Ch. 18 Cascading Declarative Referential Integrity 239
Ch. 19 Collation Enhancements 245
Pt. II Advanced DBA Topics 273
Ch. 20 SQL-Distributed Management Objects 275
Ch. 21 Microsoft Desktop Engine 283
Ch. 22 Administration 293
Ch. 23 Debugging Database Performance Issues 313
Ch. 24 SQL Server 2000 Service Pack 1 351
Pt. III Comparison with Oracle 9i 369
Ch. 25 Oracle 9i vs. SQL Server 2000 371
Ch. 26 Migrating from Oracle 9i Databases to SQL Server 2000 387
Pt. IV Scripts and Utilities 457
Ch. 27 Administration and Utility Scripts 459
Pt. V SQL Server.NET 517
Ch. 28 SQL Server 2000 and .NET 519
Appendix 527
Index 531
Auteur : SHARMA
Editeur : ADDISON WESLEY
Nombre de pages : 556
Date de publication : 04 2002
Toute la sélection
Toutes les sélections
Toute la sélection
Site réalisé en partenariat avec Courbis
(Courbis - alternate link), acteur de l'Internet depuis 1988...
Le Monde En Tique