Microsoft SQL Server 2000 Bible with CD-ROM [Paperback]

Paul Nielsen (Author)

Book Description

ISBN-10: 0764549359 | ISBN-13: 978-0764549359 | Publication Date: December 2002

Organization: The book is divided into 6 parts: Preparing to Develop with SQL Server; Building and Managing Databases with SQL Server; Managing Data with SQL Server; Implementing Business Rules with SQL Server; Monitoring and Performance Tuning with SQL Server; and Advanced Data Transfer and Analysis with SQL Server.
Comprehensive coverage: This Bible covers both beginning and advanced topics. Topics covered include: installing and configuring SQL Server; using SQL server's development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; developing stored procedures; tuning queries and indexes; and developing for English query.
Sample database applications: The book builds on sample database applications to demonstrate topics/concepts.
Sidebars: So as readers can focus on practical information, the author is using sidebars throughout to explain the best practices associated with the product and highlight material.
ABOUT THE CD-ROM
The CD-ROM contains the sample database applications and code examples in the book; SQL Server utilities; and links to Web sites, including the author's own SQL Server Web site (www.IsNotNull.com).

Editorial Reviews

From the Back Cover

"Something for everyone . . . this book includes examples to demonstrate concepts along with little-known technical information about SQL Server."
-Melinda S. King, President of Best Technology Solutions, Inc.
* Master the bestselling client/server database platform
* Build high-performance, enterprise-class databases
* Analyze data with advanced SQL techniques

If Microsoft SQL Server 2000 can do it, you can do it too . . .

Here's everything you need to harness the power of SQL Server 2000, Microsoft's high-performance, Web-enabled client/server database and data analysis package. With a focus on performance and data integrity, database expert Paul Nielsen shows you how to design performance into your database from day one. From basic installation to working with XML, monitoring, and performance tuning - a topic so hot, it merits an entire section - Nielsen provides clear instructions, sound theory, and a special "Best Practice" icon that points to the most effective way to accomplish a given task. It's more than a guidebook; it's your total SQL Server 2000 toolkit.

Inside, you'll find complete coverage of SQL Server development
* Design database schemas for performance, adapt integrity, and agility
* Understand ACID and Transactional Integrity and build rock-solid databases
* Use relational algebra to write powerful queries
* Tune indexes as the bridge between data and query
* Analyze Query Execution plans for performance
* Create T-SQL stored procedures, triggers, and user-defined functions
* Share data using DTS, distributed queries, XML, and ADO.NET
* Analyze data with Analysis Services
* Add advanced scalability, availability, performance, and portability to your database

Bonus CD-ROM!
* Sample database applications and code examples from the book
* SQL Server utilities
* Links to Web sites, including the author's SQL Server Web site, www.IsNotNull.com

About the Author

Paul Nielsen (Hickory, North Carolina) has been a programmer, computer trainer, and consultant, focusing exclusively on database development. Currently, he is a SQL Server trainer at Learning Tree International and publishes "www.IsNotNull.com,"a free, weekly newsletter for SQL Server developers. Paul co-authored Inside the Norton Antivirus (Brady, 1993) with Peter Norton. He also served as the Technical Editor for "Access Advisor" Magazine and has written over 110 computer-related articles.

Product Details

• Paperback: 936 pages
• Publisher: Wiley (December 2002)
• Language: English
• ISBN-10: 0764549359
• ISBN-13: 978-0764549359
• Product Dimensions: 8.8 x 7.9 x 2 inches
• Shipping Weight: 3 pounds
• Average Customer Review: 4.6 out of 5 stars  See all reviews (33 customer reviews)
• Amazon Best Sellers Rank: #895,993 in Books (See Top 100 in Books)

More About the Author

Paul Nielsen is a hands-on database developer, Microsoft SQL Server MVP, author, and trainer specializing in data architecture and Microsoft SQL Server technologies. His next book, SQL Server 2005 Bible, will be available in mid-2006.

Paul has been developing data-centric solutions since 1982, and was the Enterprise Data Architect for Compassion International, a SQL Server instructor with Learning Tree, the technical editor for a database magazine, and a U. S. Navy Submariner (Data Systems Tech).

He serves on the PASS (Professional Association for SQL Server) Board of Directors, and is active in the Colorado area SQL Server user groups.

For recreation, Paul enjoys scuba diving, playing guitar, and hiking in the back country of Colorado.

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

5.0 out of 5 stars Developer Depth, August 15, 2004

By 

Jonathan Smith (London, UK) - See all my reviews

This review is from: Microsoft SQL Server 2000 Bible with CD-ROM (Paperback)

SQL Server 2000 Bible is a great book for a developer. I've been a SQL Server developer since 6.5 and, while I can't speak to the admin side this, this is the book that has the level of depth and detail to keep me interested - over 10,000 lines of code, not filled with foolish filler screen shots, and great developer ideas that other books don't even touch.

There's another review that says this book doesn't have enough depth, and in another review, the same reviewer praises The Guru's Guide to T-SQL for it's depth. But, the sample code listed in the Guru's Guide review IS IN SQL Server 2000 Bible on p.384. The Guru's Guide is a good book, but SQL Server 2000 Bible has T-SQL development details and ideas not mentioned in any other SQL book that I've found. The book has 60+ pages on joins and subqueries with techniques and ideas I've never heard of. The advenced T-SQL chapter alone is worth the price of the book. If you're a SQL Server developer, you need this book.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Great resource, November 4, 2003

By 

Mike Fife (Leeds UK) - See all my reviews

This review is from: Microsoft SQL Server 2000 Bible with CD-ROM (Paperback)

This is a brilliant book, easy to assimilate and quick to progress through.
If you are new to SQL it tells you all the background you need to know, if you have done any programming previously you will find it easy to use and really informative. My copy has post-it-notes sticking out of the top with useful hints written on them. It has really enthused me.
It has great sections for the DBA too, tips on improving performance and security etc.
Truly Fabulous, I love it!

17 of 20 people found the following review helpful:

3.0 out of 5 stars Great book, poor index, July 18, 2003

By 

daleintacoma (Tacoma, WA USA) - See all my reviews

This review is from: Microsoft SQL Server 2000 Bible with CD-ROM (Paperback)

This is a great book. It's throughout and easy to read. Every time I've turned to it, it has the information I need.

Unfortunately, it is plagued by a poor index. Even the most basic SQL is missing from the index. For example, if you are interested in the TOP clause, you won't find it between "tools, developer" and "torn-page detection". Instead you need to look under "Select statement, rows, return few (top keyword)".

With a better index, this book would be more than a great learning tool, but a great reference tool too.