SQL Server 7 Developer's Guide

Features

• Cover Type: Paperback with 875 pages
• Published by: Osborne Publishing December 1, 1998
• Written in: English
• ISBN 10 Number: 0078825482
• ISBN 13 Number: 978-0078825484
• Book Dimensions: 9.1 x 7.3 x 2 inches
• Weighs: 3.5 pounds

Product Review
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
Serve up optimal database solutions with SQL Server 7 Get vital information for developing SQL applications and administering and managing SQL Server in your enterprise environment. SQL Server 7 Developer's Guide by Michael Otey is a breakthrough resource that takes a 360-degree view of SQL to help you take control of database administration and application development. Reduce total cost of ownership within your organization with start-to-finish coverage of core SQL Server 7 concepts including: *Administration techniques using MMC and the Enterprise Manager *Data access using Transact-SQL, SQL-DMO, ODBC, DB-Library, DAO, ODBCDirect, RDO, OLEDB, and ADO *Breaking the speed limit on response times *Performance tuning using SQL Profiler *Rapid development using Access *Web integration using ASP o*Integrated security and roles Includes Data Access Wizards on CD with ready-to-use code samples. programs access APIs in action on your own system!

Reader Reviews
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!