Sql Server 7 Developer's Guide

Customers who bought this book also bought:

Microsoft Sql Server 7 Dba Survival Guide : A Real-World Solution; Mark Spenik, et al
SQL Server 7: The Complete Reference; Gayle Coffman
Sql Server 7 Data Warehousing; Michael Abbey, et al
Hands On SQL Server 7 with VB6; Wayne S. Freeze

Reviews
Amazon.com
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 opens with overviews of the SQL Server database architecture and the new features of version 7. The management and security aspects of the all-important Enterprise Manager are covered in depth. The authors make very liberal use of screen shots and information tables, lending a visual look to this introduction. The first part continues with sections on replication, data warehousing, performance optimization, and SQL-DMO--the object-oriented framework that lets you write your own management applications.

Part 2 opens with a traditional look at databases and a focus on the relational model. After introducing you to entity-relationship diagrams and a rather detailed tutorial of the SQL language, the authors present each of the various ways to access SQL Server from client applications: Microsoft Access front ends, data access objects (DAO), Open DataBase Connectivity (ODBC)Direct, the ODBC API, Remote Data Objects, object linking and embedding database (OLE DB), ActiveX Data Objects, and DB-Library. The last chapter discusses Active Server Pages (ASP) development and how to integrate SQL Server databases with Web sites.

A companion CD-ROM contains all of the example code in the book and offers a centralized interface for running it. --Stephen W. Plain

Book Description
Excellent author-recognition factor! Mike Otey is the VB Solutions columnist for Windows NT Magazine; Paul Conte is a published author and database expert! Unique coverage of core SQL Server topics combined with step-by-step application development. Written from a Visual Basic development angle covering topics such as SQL DMO, Extended Stored Procedures, ODBC and the VBSQL OCX.

Synopsis
A developer's guide targeted at developers who are faced with having to build a SQL Server database, this definitive, professional guide includes a Visual Basic development angle--with such topics as SQL DMO, Extended Stored Procedures, ODBC, and the VBSQL OCX. The CD includes features that will save hundreds of man-hour programming time in building databases, as well as help walk the user through a sample, real-life process.

Back to Database Management Systems
Back to Databases
Back to Main Index