SQL Server 2000 Developer's Guide [With CDROM]

by Michael Otey and Paul Conte

This text coaches the reader from beginning to advanced topics to increase their understanding of SQL Server 2000, and guides them to developing their own applications. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072125691
• ISBN13: 9780072125696
• Release Date: December 2000
• Publisher: McGraw-Hill/Osborne Media
• Length: 1300 Pages
• Weight: 4.75 lbs.
• Dimensions: 2.6" x 7.3" x 9.1"

Customer Reviews

If you could only buy one book, this would be it...

Excellent. Paul Conte and Mike Otey are well known in the Midrange AS/400 world for their concise, no-nonsense approach to programming the AS/400 in a variety of languages(i.e. C, RPG, SQL/400, etc.). Here, in the SQL Server world, starting with "SQL Server 7 Developer's Guide", and now for SQL Server 2000, they apply the same style and manner and succeed admirably. The book is chock-full of examples, and performance tips, and even includes a SQL primer! They leave no stone unturned, and cover every aspect of SQL DDL, DML, and T-SQL. Lastly, their coverage of OLEDB/ADO and XML completes the picture. As I said, if you could only buy one book on SQL Server 2000, this is the one to buy!

The Best SQL Server 2000 book out there!

This book really covers SQL Sever 2000 with clear, uncomplicated explanations and useful examples. I have used it as a reference guide to answer questions that have come up, as well as a jumping off point for writing my own applications to SQL Server 2000. I can cut and paste the code from the CD right into my programs.The authors cover many of SQL Server 2000's features including: T-SQL's DDL and DML, stored procedures and triggers, ADO and ASP, XML, SQL-DMO, DTS, security, backup and recovery, and more. Having so much practical information all in one place has sure been a time saver for me.A very well rounded and easy to read book. Definitely a must have!

Full subject reference with succinct, to the point practices

I found this book to be an excellent resource in understanding the proper methods for deploying SQL Server 2000 in the development of applications. The orientation of the material is to frame the subject matter in a concise, meaningful conceptual overview and then to step you through clearly written sequence of techniques for doing the work. Along the way, as the writers uncover key issues and choices in the methods, they state perferred paths through the thicket of options. You get the benefit of experience and confidence in their reporting because they have included a CD of the code they have used in the book.The book is host to all the subjects a developer using this software requires -- from the Transact-sql query language and application interface coding to management of applications. Older programming standards for interfacing an application with SQL Server are given thorough coverage and will help preserve continuity in coding made previously with earlier versions of SQLServer. At the same time, the new Microsoft initaitives in ADO are given in depth treatment as well.

SQL Server Bible!

If you've tried finding answers about SQL Server on Microsoft's Web site, you already know that Microsoft's documentation is a mishmash of manuals, technical notes, and forum discussions. It's virtually impossible to get a clear picture of how to use SQL Server from this stuff. SQL Server 2000 Developer's Guide is a great "master index" to SQL Server 2000 -- it covers everything! But more than that, it provides complete, _working_ examples on the accompanying CD, which is a vast improvement over Microsoft's unusable code "snippets." I especially like the charts that relate SQL Server features to tasks and capabilities. This makes it easy to figure out what SQL thing to use to accomplish a particular task. Better, the book gives you step-by-step procedures so that you do things in the right order, rather than thrashing around in Microsoft's peculiar dialog boxes. This book doesn't cover every aspect of SQL Server in detail -- it's an essential adjunct to Microsoft documentation rather than a replacement for it. But I never needed a replacement to the manuals, just a map with example code and lots of helpful tips. That's what SQL Server 2K DevGuide is!

Good overall reference

This is a hefty book that so far looks like a good choice for my first SQL Server 2000 book. The core stuff on T-SQL and ADO is solid and does a good job on new features like cascading foreign keys. The additional topics are what have really made this book a good value for me. As examples, this is the first SQL Server book I've found that grapples with Windows 2000 Server Active Directory and how to use it with SQL Server security. The XML coverage is also top notch and got me over several hurdles quickly. Some of the admin areas, like backup and recovery, aren't covered as deeply as in books targeted specifically at DBAs, however.The writing is very clear and direct and there's lots of example code. Although I've found a few typos, so far the technical information seems accurate. In several places, the authors provide useful tables that bring together information that's spread around different topics in the on-line documentation. I also found their recommendations for specific database settings and coding techniques helpful.