Customer Reviews

SQL Server 2000 Developer's Guide

5 star:		(11)
4 star:		(1)
3 star:		(2)
2 star:		(0)
1 star:		(1)

 

 

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!

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!

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.

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!

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.

Excelent book. Clear explanations,cover all areas,full with examples,error free.This book is writen from developers for developers.Not for absoulte begginers,this book goes in advanced topics very fast.Before to notice, you will start to write advanced queries,triggers...DML and DDL are explainded so clear,they look so simple now,AFTER this book... Highly recomended!!

The book title is some what misleading since there is a lot of coverage on front end developement. When I purchased this book I was expecting a strictly SQL Server Developer book, not a visual basic programmers reference, it also through me off when I discovered 4 chapters dedicated just to SQL Server Administration. If you want a jack of all trades book then this book might help, but it is certainly not just strictly for SQL Server development only which is what I was looking for.

You guys again did a great job on this book! I owned your previous version for SQL Server 7 and thought it was great and wrote a great review. Subsequently when the next version came out, I received an email from either Paul Conte or Michael Conte asking me if I wanted a complementary copy of the new book. Of course I said yes (sorry Amazon, I didn't buy the 2000 version from you) and it arived ASAP. Unfortunately, I didn't have the opportunity to use SQL Server 2K until about a week ago and have found the book invaluable since then. It is not a book for beginners, however, it is written in a straight forward manor and is enjoyable to read (how many technical books can you say are enjoyable to read?) and gives me the info I need to develop apps. utilizing SQL Server. Thanks again for a great, well written technical book!!!

First of all, let me say that this book is not meant for End-Users, Administrators or Analysts. It is strictly for Developers and Programmers and does not cover the SQL Server 2000's interface, nor its various tools.

This book does contains an in-depth look at SQL Server programming, including Stored Procedures, Cursors, Triggers and ADO. It covers plenty of programming topics and issues, but does not dive into much detail about certain topics that deserve more attention. Also it lacks examples (specifically data output examples) and screen-shots.

Other than that, it is a good book to have, but I would not recommend it to novice programmers. I do however, recommend SQL Server 2000 Programming by Example, which covers a narrower range of topics, but in a lot more detail.

I owned the predecessor to this book, the SQL Server 7 Developer's Guide, and found it very useful. It was so useful, in fact, that when I loaned it to a colleague, I had to practically wrestle it away from him to get it back!

This is a great, HUGE, and even more useful update to the SQL Server 7 book, and it's already proven invaluable. The sample code on the CD has already helped me on a current project. I highly recommend this book!