Microsoft SQL Server 2000 Unleashed, 2nd Edition

Overview

Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL ...

See more details below
Available through our Marketplace sellers.
Other sellers (Multimedia Set)
  • All (18) from $1.99   
  • New (2) from $50.00   
  • Used (16) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$50.00
Seller since 2014

Feedback rating:

(147)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(147)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
SQL Server 2000 has been out for years now. But Microsoft hasn’t stood still. We’re not just talking about three Service Packs. There are huge improvements to SQL Server’s XML and Web integration (especially SQL XML 3.0). There’s new support for ADO.NET and the entire .NET Framework. There are new Notification Services for automating information delivery to subscribers. And of course, there’s a new 64-bit version for truly gigantic databases (in late beta as we write this).

SQL Server 2000 Unleashed hasn’t stood still, either. It’s followed right behind Microsoft, adding coverage of a wide range of new features that Microsoft’s added to SQL Server 2000. In this Second Edition, the authors have also expanded quite a bit of their First Edition coverage -- notably, their chapters on Query Analyzer and SQL Profiler.

Weighing in at more than 1,500 pages, this book is anything but padded. It’s useful from start to finish. The most exhaustive coverage is dedicated to the core database product itself, day-to-day administration and management, to programming with Transact-SQL, and to the database engine’s newest features. On the other hand, when it comes to features like DTS, Analysis Services, and full-text search, you have to settle for…well, really solid discussions of the fundamentals. Even here, the stuff’s darned good -- just not quite as deep.

If you’ve been around the block a few times with SQL Server, this book will help you accomplish far more, far more efficiently. For example, you’ll find nearly 400 pages on performance optimization -- utterly crucial in this age of constrained IT budgets. The authors walk you through SQL Server’s internals -- how it manages memory, processes, and I/O; how its tables and indexes are structured “under the hood.” Once you understand that, you can really go to work on improving performance.

You’ll find detailed chapters on query optimization and query analysis, followed by a practical review of performance monitoring (what to monitor and what the numbers mean). You’ll understand how locking impacts performance and what you can do about it. There’s a complete “short course” in high-performance database design. Last but not least, there’s a far-reaching discussion of optimizing SQL Server configuration options for performance -- everything from affinity masks to user options.

There’s exhaustive coverage of T-SQL, including its newest datatypes, user-defined functions, and indexed views. You’ll start with simple INSERTs, UPDATEs, and DELETEs; move through cursors, views, stored procedures, and triggers, and finally master transactions and distributed transaction processing.

But we’ll save our greatest hosannas for the authors’ practical coverage of SQL administration. If you’re a DBA, this book is truly the single source resource it aims to be. From installation and upgrades to client configuration and database creation, you’ll find it here. You’ll learn all you need to manage tables and indexes, enforce data integrity, backup and restore databases, manage users -- and of course, improve SQL Server’s traditionally less-than-stellar out-of-the-box security.

The whole book’s on CD-ROM (so you won’t have to lift it!) The disc also contains goodies ranging from T-SQL code and data replication scripts to XML examples and sample stored procedures (plus loads of trialware). This book’s a big winner -- in more ways than one. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.

Read More Show Less

Product Details

  • ISBN-13: 9780672324673
  • Publisher: Sams
  • Publication date: 12/18/2002
  • Series: Unleashed Series
  • Edition description: Subsequent
  • Edition number: 2
  • Pages: 1513
  • Product dimensions: 7.40 (w) x 9.10 (h) x 2.21 (d)

Meet the Author

Ray Rankins is currently owner and president of Gotham Consulting Services, Inc. (www.gothamconsulting.com) near Saratoga Springs, New York. Ray has been working with Sybase and Microsoft SQL Server for more than 15 years as a database administrator, database designer, project manager, application developer, consultant, courseware developer, and instructor. He has worked in a variety of industries including financial, manufacturing, health care, retail, insurance, communications, public utilities, and government. His expertise is in database performance and tuning, query analysis, advanced SQL programming and stored procedure development, and database application design and development. Ray's presentations on these topics at user group conferences have been very well received. Ray is coauthor of Sybase SQL Server 11 Unleashed, Sybase SQL Server 11 DBA Survival Guide, Second Edition, and Microsoft SQL Server 6.5 Unleashed (all editions), all published by Sams Publishing, and he has written articles for publication in database-related periodicals. As an instructor, Ray regularly teaches classes on SQL, advanced SQL programming and optimization, database design, database administration, and database performance and tuning. Ray's ability to bring his real-world experience into the classroom consistently brings very high marks from students in his classes for both his instructional skills and courseware. He can be reached at rrankins@gothamconsulting.com.

Paul Bertucci is a senior director with Collaborative Consulting, LLC of Boston, Massachusetts (www.collaborative.ws). He leads the San Francisco, California database and performance engineering practices. He was formerly the founder of Database Architechs (www.dbarchitechs.com) and he has more than 20 years of experience doing database design, data architecture, data replication, performance and tuning, distributed data systems, data integration, and systems integration for numerous Fortune 500 companies including Intel, 3COM, Apple, Toshiba, Lockheed, Wells Fargo, Safeway, Texaco, Charles Schwab, Cisco Systems, Sybase, Webgain, Breg, Channell, and i2 Technologies. He has authored numerous articles, standards, and courses such as Sybase's "Performance and Tuning" course and "Physical Database Design" course. Paul is a frequent conference speaker and regularly teaches database design, performance and tuning, data modeling, OLAP, Supply Chain Management, and SQL courses. He has worked heavily with MS SQL Server, Sybase, DB2, and Oracle, and has architected several commercially available tools in the database, data modeling, performance and tuning, and data integration arena. Paul serves part-time as chief technical advisor for a data integration server software company as well as an advisory board member of a software services company in Silicon Valley. Paul received his formal education in computer science from UC Berkeley. He lives in northern California with his wife, Vilay, and five children, Donny, Juliana, Paul Jr., Marissa, and Nina. Paul can still be reached at pbertucci@dbarchitechs.com or also at pbertucci@collaborative.ws.

Paul Jensen is an MCDBA, MCT, MCSE, and OCP (Oracle Certified Professional) who has been involved with database and system administration for almost 15 years. His experience has made him a popular trainer, and the past few years have seen him bouncing around North America and Europe in his role as an MCT, bringing new SQL Server converts into the fold. Paul lives in Ottawa, Canada, and can be contacted through his Web site at www.infojen.com.

Read More Show Less

Table of Contents

Introduction 1
Pt. I Welcome to Microsoft SQL Server
1 The Microsoft SQL Server Environment 9
2 SQL Server 2000 Environments and Editions 31
3 What's New in SQL Server 2000 45
Pt. II SQL Server Tools and Utilities
4 SQL Server Enterprise Manager 59
5 SQL Server Command-Line Utilities 85
6 SQL Server Query Analyzer and SQL Debugger 99
7 Using the SQL Server Profiler 129
Pt. III SQL Server Administration
8 Installing and Upgrading SQL Server 171
9 Client Installation and Configuration 195
10 SQL Server System and Database Administration 215
11 Creating and Managing Databases 225
12 Creating and Managing Tables in SQL Server 245
13 Creating and Managing Indexes 269
14 Implementing Data Integrity 277
15 Security and User Administration 295
16 Database Backup and Restore 317
17 Database Maintenance 357
18 SQL Server Scheduling and Notification 369
19 Managing Linked and Remote Servers 385
20 Importing and Exporting SQL Server Data Using BCP and DTS 409
21 Administering Very Large SQL Server Databases 469
22 Data Replication 477
23 SQL Mail 535
24 SQL Server Clustering 561
25 Defining System Administration and Naming Standards 573
Pt. IV Transact-SQL
26 Using Transact-SQL in SQL Server 2000 601
27 Creating and Managing Views in SQL Server 707
28 Creating and Managing Stored Procedures in SQL Server 731
29 Creating and Managing Triggers 817
30 User-Defined Functions 847
31 Transaction Management and the Transaction Log 871
32 Distributed Transaction Processing 909
Pt. V SQL Server Internals and Performance Tuning
33 SQL Server Internals 931
34 Indexes and Performance 1035
35 Understanding Query Optimization 1079
36 Query Analysis 1139
37 Monitoring SQL Server Performance 1165
38 Locking and Performance 1189
39 Database Design and Performance 1249
40 Configuring, Tuning, and Optimizing SQL Server Options 1269
Pt. VI Additional SQL Server Features
41 Using XML in SQL Server 2000 1305
42 Microsoft SQL Server Analysis Services 1339
43 Microsoft Transaction Server 1383
44 SQL Server Full-Text Search Services 1405
45 SQL Server Notification Services 1417
46 SQL Server and the Microsoft .NET Framework 1433
47 English Query 1453
Index 1465
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)