SQL Server 2000 Developer's Guide [Paperback]

Michael Otey (Author), Paul Conte (Author)

Book Description

ISBN-10: 0072125691 | ISBN-13: 978-0072125696 | Publication Date: December 22, 2000 | Edition: 2

"A great reference on SQL Server 2000, loaded with excellent code examples." --Sean O'Farrell, Manager, Business Integration, Eli Lilly and Company This book includes full coverage of Transact-SQL's DDL, and DML as well as ADO, DAO, and RDO. You'll learn to build scaleable SQL Server 2000 Web solutions and handle database management, backup, recovery, and security.

Editorial Reviews

From the Publisher

The book includes in-depth discussions of Transact-SQL to create and manipulate database objects, using the principal programming interfaces (e.g., ADO, DAO, ODBCDirect, ODBC, and RDO) to access the database, writing stored procedures and extended stored procedures, developing integrated, cross-platform Web applications with ASP and XML, replicating data to multiple systems, setting up security, performance monitoring and tuning, backup and recovery, managing databases with the Enterprise Manager, relational database design, and more.

SQL Server 2000 Developer’s Guide is unique in it’s comprehensive coverage of all the relevant database topics from the perspective of the database application developer. The reader gets a superb explanation of Transact-SQL, which lies at the heart of SQL Server 2000, as well as fully-working sample applications and explanations to quickly get started with any of the principal programming interfaces. But, SQL Server 2000 Developer’s Guide goes further to explain key database design and database administration topics, such as security and performance, so the developer is armed with all the knowledge needed to succeed in real-world development settings.

The 1200-plus pages include all the necessary technical information and directions for using various features and tools, but you won’t find space wasted, for example, with re-printed syntax diagrams from the on-line documentation. And, unlike the Books Online topic organization, you won’t have to bounce around to pull together all the relevant details for a particular topic. For programmers who already know the basics of SQL Server, the extensive index (over 4,000 entries) lets you can go straight to a section that covers a particular feature of interest and quickly learn about it.

From the Author

Based on our own experience as commercial application developers, we’ve tried to explain all aspects of database development you need to know to create top-quality, production databases and applications. We cover database design, T-SQL programming, writing applications with all the principal interfaces (e.g., ADO, DAO, ODBCDirect, ODBC, and RDO), and the key administrative areas of security, performance, and backup and recovery.

In writing this book, we tried to avoid simply repeating information you’ll find in the SQL Server 2000 Books Online documentation. Instead, we’ve provided tutorials on all the important SQL Server 2000 features and tools and described how to uses them to solve common development problems. You won’t find space wasted, for example, with re-printed syntax diagrams from the on-line documentation. Each chapter is designed so you can read it start-to-finish to efficiently learn all the essential aspects of the topics covered in the chapter. To bolster these explanations, we’ve included lots of examples (including full project source code on the CD), as well as specific design, coding, performance, and security “best practice” recommendations.

For those of you familiar with our previous book, SQL Server 7.0 Developer’s Guide, we want to point out we’ve completely re-structured and rewritten the new book to incorporate all the latest features and recommended techniques. We didn’t just add a “fix pack” to the previous book to produce this one. You’ll also find many more code examples and a greatly expanded index.

We hope you enjoy the book!

– Mike Otey and Paul Conte

See all Editorial Reviews

Product Details

• Paperback: 1248 pages
• Publisher: McGraw-Hill Osborne Media; 2 edition (December 22, 2000)
• Language: English
• ISBN-10: 0072125691
• ISBN-13: 978-0072125696
• Product Dimensions: 9.1 x 7.5 x 2.7 inches
• Shipping Weight: 4.5 pounds
• Average Customer Review: 4.4 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #2,274,479 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

19 of 20 people found the following review helpful:

5.0 out of 5 stars If you could only buy one book, this would be it..., February 21, 2001

By 

F. M. Villafane "sci-fi fan" (Eatontown, NJ USA) - See all my reviews
(REAL NAME)   

This review is from: SQL Server 2000 Developer's Guide (Paperback)

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!

18 of 20 people found the following review helpful:

5.0 out of 5 stars The Best SQL Server 2000 book out there!, January 11, 2001

By 

Catherine Martinson (Las Vegas, Nevada) - See all my reviews

This review is from: SQL Server 2000 Developer's Guide (Paperback)

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!

10 of 10 people found the following review helpful:

5.0 out of 5 stars Good overall reference, January 5, 2001

By 

Tina Clausen (Lexington, KY) - See all my reviews

This review is from: SQL Server 2000 Developer's Guide (Paperback)

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.