SQL Server 7 Developer's Guide [With *]

by Michael Otey and Paul Conte

SQL Server 7 Developer's Guide is equally divided into a database administrator's manual and a developer's primer, providing useful content for readers who are interested in both angles. The book... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0078825482
• ISBN13: 9780078825484
• Release Date: December 1998
• Publisher: McGraw-Hill/Osborne Media
• Length: 975 Pages
• Weight: 3.80 lbs.
• Dimensions: 2.0" x 7.3" x 9.1"

Customer Reviews

Excellent reference for SQL Server 7 developers

This book covers nearly every aspect of SQL Server 7 that could be relevant to the developer. Sections on SQL Server's architecture and administration, backup, security, replication, and other DBA aspects, comprise the first part of the book. The remainder of the book is geared towards the development aspect, rather than the administrative aspect. The section on T-SQL is very good. There are many illustrations and examples throughout the book and the language is easy to read.While there are books out there, many of them excellent, that concentrate on the adminstration of SQL Server to the exclusion of development and others that are directed only at developers, this book is geared to the developer that needs to dabble in administration from time to time. This is what makes this book unique and an important addition to any SQL Server 7 developer's library.

This book rocks

I'm a recent college graduate and this book is teaching me a lot. This book is very usefull for me becuase I work for a small startup e-commerce company (12 employees, 4 IT/Graphics) and I function as both a DBA and an ASP webdeveloper. This book gives a lot conceptual teaching with very good example support. It is one of the best teaching books i have bought.I learned the microsoft proprietary exensions in T-SQL for doing Stored proceedures and Triggers so I can tranform some of the SQL intensive ASP code into stored proceedure/triggers, Database replication that will hopefully make me not have to use DTS quite so much, learned how to link access to SQL server so I can use access's automated featurers to program the website admin capabilities much faster and make it more user-friendly, and handle SQL server security so all the employees can at least read from the database without having to give it a password, but only the website or the admin pages can write to the database and Me and one other person can do the admin and backup stuff to the SQL server.This book does not teach database design (It teaches some stuff on the relational model for pruposes of SQL programming, but not for proper design and normaliztion), so if you want to learn how to design and normalize databases, look for an extra book, like O'reilly's Access Database design and programming (Nearly half of the book is database design, and it is very good in conceptual teaching so you can easily transfer the knowledge to other platforms - SQL Server, Oracle, etc..) This book does do an exceptional job in what it does teach though - database integration programming and SQL Server admin / programming. Also, beign a hybrid admin/programming book , don't expect to to appease hardcore programmers, or veteran DBAs, but if you are a recent college graduate, or only been in the industry for a few years, and you do a lot of database oriented programming (E-Commerce, etc..), and especially if you have a role over the administration or programming (Stored procedures, triggers, etc..) of the SQL server for the website, GET THIS BOOK!

I's a must have

This is an excellent book. It covers the access techniques to the databases of SQL more common Server 7 as DAO, RDO, ODBC, ODBCDirect, DB-Library, SQL-DMO and ADO among others. The chapters that are about the administration, implementation of SQL Server 7 and the related topics are very good. This book well could be good as preparation for the exam 70-029. (Not only of course). The chapter that covers the material of SQL-DMO is one of the best of the book. The example that comes in the CD is very excellent. The chapter that is about MS Access connection with SQL Server is excellent. The final part of the book outlines the capacity of SQL Server to convert you paginate from results of consultations to the format HTML to be used in an intranet or internet. In the CD some example projects come. 1 in Access, several in Visual Basic and 1 in Visual Interdev. All examples are very instructive, without exception. The examples in Visual Basic 6 are all magnificent ones, without caring the experience that one has. I am relatively new programming in Visual Basic and I have already been able to make a very interesting program thanks to the content of the book. Buy it! It is wonderful. If you are intelligent the book will be very useful. If not, you will need something very elementary.

The most complete SQL Server - VB Developer Reference

I have been developing database applications with Visual Basic since version 3.0 of the product was released several years ago. When SQL Server 7.0 was released, I needed to find a complete reference guide that would help me. It had to be a well laid out guide with sample code to help me build highly flexible and scaleable SQL database solutions. This book does it! Not only have I used it to develop VB to SQL Server solutions, but MSAccess to SQL Server and believe it or not, VB and MSAccess to Sybase SQL applications!Because both Sybase and SQL Server understand the Transact SQL format, it was a helpful! The documentation in the book was so good, I have not yet even taken a look at the included CD-ROM!I want to encourage ANY intermediate to advanced VB/Database developer to buy this book! BUY THIS BOOK FELLOW VBers and Access developers!!!!!

Excellent resource for the SQL server developer

As someone new to SQL Server (my company is mainly Oracle), I found this book to be a handy tool. The authors included refreshingly practical explanations and examples for "real-world" enterprise development. Included were extensive details on interfaces, including: OLE DB and ADO; ODBC API (call-level interface); RDO; and VB DAO and ODBCDirect. I found helpful explanations for integrating SQL Server 7 databases with the Web and developing Active Server Pages, which is what I bouhgt the book for.Of course, this being a book on SQL Server, it is very Microsoft-centric, with examples pointing toward VB and Visual C++, but I expected this.All in all an excellent resource.