NMON Network Monitoring: Books: Building Microsoft(r) SQL Server(r) 7 Applications with COM

Building Microsoft(r) SQL Server(r) 7 Applications with COM
	Author: Sanjiv Purba Publisher: John Wiley & Sons Category: Book List Price: ~~$39.99~~ Buy New: $6.00 You Save: $33.99 (85%) Buy New/Used from $0.03 Avg. Customer Rating: (3 reviews) Sales Rank: 3764495 Languages: English (Original Language), English (Unknown), English (Published) Media: Paperback Edition: 1 Number Of Items: 1 Pages: 506 Shipping Weight (lbs): 1.9 Dimensions (in): 9.2 x 7.6 x 1.3 ISBN: 0471192333 Dewey Decimal Number: 005.7585 EAN: 9780471192336 ASIN: 0471192333 Publication Date: February 19, 1999 Availability: Usually ships in 1-2 business days

Editorial Reviews: Product Description Total coverage of the latest SQL Server release, from a leading SQL expert. With the release of Microsoft SQL Server 7, client/server developers must master the latest features and SQL's new architecture--vastly different from earlier editions. To build full-scale business applications, they will also need to learn how to harness the power of COM distributed objects and MTS. This book will ease the pressure, providing a complete tutorial on each developmental phase, from planning and design to prototyping, coding, and reporting. Amazon.com Review Written for the database administrator or developer, Building Microsoft SQL Server 7 Applications with COM provides a solid working guide to what's best in the latest release of SQL Server. The book begins with a general introduction to SQL Server 7, including its administrative wizards and tools. (The author admits that SQL Server may not be the fastest, but it provides better ease of use than its competitors.) Author Sanjiv Purba offers hints for installing the product and using tools such as Enterprise Manager. The guide takes you through today's multitiered system architectures, providing an overview of COM as well as Microsoft Transaction Server (MTS) for transaction management on the middle tier. Several chapters demonstrate common administrative and programming tasks using both wizards and Transact-SQL for building tables, queries, and views. Further sections show how to implement a physical database in SQL Server 7. (The full coverage of SQL Server 7 configuration settings stands out as excellent material.) Information on SQL Server data types and data validation through constraints and rules follows, along with some superior information on leveraging the power of stored procedures and triggers. Later the author presents a short case study for a simple three-tiered database application using a Visual Basic 6 module on the middle tier. He briefly touches on Internet-related issues with a quick tour of tools such as Visual InterDev and the SQL Server Web Assistant Wizard. Final chapters offer tips for testing, optimizing, and administering SQL Server 7. This book is best at introducing what's new and improved in SQL Server 7, with an emphasis on simpler administration and the server's potential to make use of the middle tier in today's enterprise systems. --Richard Dragan

Customer Reviews: Confusing and not helpful October 4, 1999 1 out of 1 found this review helpful This is a very confusing book. A lot of concepts are explained extremely poorly and I got totally lost after a short while. Get another book from Amazon instead. Good book, but... September 10, 1999 4 out of 5 found this review helpful This was a good book. It is a great guide to SQL 7, and can be used as a good primer on interacting with it. The book explains how to use the wizards to accomplish tasks (important for beginners), as well as how do the same thing with straight SQL language from the Query Analyzer (valuable as a learning tool and a reference). Nevertheless, by the nature of the title, you would expect a lot of COM-related development content. If you count ADO (which I don't in this instance), then the title is justified. There are only a couple of chapters on developing COM objects that interact with SQL 7 near the end. It seems like the word COM was tossed in purely for marketing purposes. So final word on "Building Microsoft SQL Server 7 Applications with COM" is that it is great on SQL 7, but weak on COM. No code CD attached to the Book May 14, 1999 1 out of 1 found this review helpful I couldn't find source code for this book on publisher's web site. That mean to test those code I have to type all code myself. If I had know it I wouldn't buy this book. I thought this is commone scense for reader to expect the code is either come with an attached CD or can be downloaded.

For your safety and security, orders are processed through amazon.com