SQL Server� Developer′s Guide - Softcover

Bambara, Joseph J.; Allen, Paul R.

9780764546723: SQL Server� Developer′s Guide

Softcover

ISBN 10: 0764546724 ISBN 13: 9780764546723

Publisher: John Wiley & Sons, 2000

View all copies of this ISBN edition

1 Used

From � 118.31

0 New

SQL Server Developer′s Guide The Latest Tools and Best Techniques for Fast Results Packed with enterprise–tested strategies and solutions, this unique guide gives you a comprehensive catalog of best practices for SQL Server development. Drawing on a combined 25 years of database experience, two veteran developers lead you through the entire lifecycle of a database system, from preliminary modeling to operational rollout. Along the way, they show you how to utilize C and Java as well as the Microsoft Visual Studio languages –– and capitalize on the enhanced functionality of SQL Server. Whether you need to jumpstart a new e–commerce project or fine–tune an existing data warehousing system, this incisive guide is an invaluable reference. Your Complete How–to Guide

Model your application using CASE Tools "Lite" or Erwin
Design Web, client/server, or object–oriented systems
Utilize SQL administration tools and utilities, from Dtswiz to Sqlmaint
Design effective interfaces using styles, libraries, scripts, and help systems
Master the nuts–and–bolts of data definition, from table syntax to locking
Build efficient C and Java programs with SQL
Fine–tune performance using tips on partitioning, procedures, and triggers
Get SQL standards, guidelines, and maxims, as well as advice on third–party tools
www.idgbooks.com

"synopsis" may belong to another edition of this title.

Review

Because it underlies the information infrastructure of so many organisations, Microsoft SQL Server is a great place for systems experts to extend their knowledge beyond general familiarity. By acquiring a programmer's knowledge of this robust database solution, you can make yourself far more valuable than an ordinary system administrator. SQL Server Developer's Guide will get you started using Structured Query Language (SQL), Java and C to build SQL Server 7 applications. You will have to back this book with a language text if you lack general programming skills, but SQL Server Developer's Guide does a competent job of explaining how SQL Server interacts with software designed to read and write databases.

Some readers will object to the inclusion of general programming advice about such topics as debugging and source management. It sometimes seems that the authors, given a chance to write a programming book, tried to include lots of accumulated wisdom. It is often interesting reading, but is not always relevant to developing software for interaction with Microsoft databases. When it gets down to SQL Server programming, however, the book does a great job of explaining how the server and its programming interfaces work. The text, combined with line drawings, explain concepts and uses a variation on traditional syntax documentation for illuminating aspects of the SQL language (and SQL does, by the way, get more attention here than any other language). Specifically, the book devotes far more space to parameters of each statement than is typical elsewhere--a helpful approach. --David Wall

About the Author

About the Authors Joseph J. Bambara and Paul R. Allen have developed applications systems for financial, brokerage, and manufacturing firms and have extensive experience with PowerBuilder, Java, and other development tools. They have cowritten books on PowerBuilder and Informix and have taught database development courses around the world.

"About this title" may belong to another edition of this title.