Microsoft SQL Server 2000 Bible [With CDROM]

by Paul Nielsen

Book Overview

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...

• Format: Paperback
• Language: English
• ISBN: 0764549359
• ISBN13: 9780764549359
• Release Date: September 2002
• Publisher: John Wiley & Sons
• Length: 936 Pages
• Weight: 3.35 lbs.
• Dimensions: 2.0" x 7.9" x 8.8"

Customer Reviews

Something for Everyone

When it comes to building databases, this book organizes chapters into an easy-to-follow logical sequence. Nielsen offers something for everyone in this book by taking you from modeling a logical database design, to implemtation, to performance tuning. He provides easy-to-follow examples all throughout the book. Personally, I found his "Best Practice" opinions and suggestions priceless!

Begin'ers + Mid Lvls Using SQL Svr 2K-- Get this book!!!

Begin'ers + Mid Lvls Using SQL Svr 2K-- Get this book!!! ...Have experience with programming langs. like c++, java, vb, c# (and other procedural and OOP langs.)? Having trouble transitioning from procedural and OOP langs to set/list based T-SQL? Get this book. This book is great. Plenty of explanations of T-SQL concepts. The author is a good writter. Many thanks to the author and publisher for putting the entire book on the CDROM as a PDF file. Now I can take the book with me without the extra weight. I have it on my laptop. I will be studying for my 1st SQL exam in two months, but in the mean time I'm able to finish my DB project at work now. I bought it because I wanted to be able to write stored proc's., user defined functions, sub-queries, DTS packages, and learn how to schedule jobs in SQL Server. Also I needed some well explained examples of creative uses of select statements and sub-queries. The author delivers. For example, turning a single column in a table into a comma separate value list (CSV list). Which is often used with look-up tables used to populate a drop-down list or multi-select list. --------------------- DECLARE @strValue VARCHAR(30) SET @strValue = '' SELECT @strValue = @strValue + tbl_Cities.CityName ',' FROM tbl_Cities Result is like... "New York City,Chicago,Miami,Dallas" --------------------- There is another book that is recommended/hailed as the best T-SQL book, but this book will get you up and running fast and offers more than just T-SQL... plenty of SQL Server admin content and practice advice that is used in the real world.

Developer Depth

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.

Great resource

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!

Great Best Practices

Used the Best Practices within the work environment. Great to have a guideline from which to work from. Most books say you can do 6 of one half a dozen of another, but not recommend the best approach. I like that the author goes out on a limb to make these "Best Practices".