SQL Server® Developer's Guide [Paperback]

Joseph J. Bambara (Author), Paul R. Allen (Author)

Book Description

ISBN-10: 0764546724 | ISBN-13: 978-0764546723 | Publication Date: April 3, 2000 | Edition: 1

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

Editorial Reviews

Amazon.com Review

Because it underlies the information infrastructure of so many organizations, 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 in the use of Structured Query Language (SQL), Java, and C to build SQL Server 7.0 applications. You'll 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 that's 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's often interesting reading, but it's not always relevant to development of 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, which is combined with line drawings, explains concepts and uses a variation on traditional syntax documentation for illuminating aspects of the SQL language (and SQL, by the way, does 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

Topics covered: Microsoft SQL Server 7.0 for hacker-minded database administrators and software developers, with emphasis on the SQL Server Development Tools, aspects of SQL itself, and interaction between SQL Server and programs that are written in Java and C. Stored procedures and triggers, appropriately, get extra attention.

From the Publisher

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

See all Editorial Reviews

Product Details

• Paperback: 573 pages
• Publisher: Wiley; 1 edition (April 3, 2000)
• Language: English
• ISBN-10: 0764546724
• ISBN-13: 978-0764546723
• Product Dimensions: 9 x 7 x 1.5 inches
• Shipping Weight: 2 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #4,708,447 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

4.0 out of 5 stars SQL Developers's Guide is usable & comprehensive, March 31, 2000

By 

Pierre Writouche (Brugge) - See all my reviews

This review is from: SQL Server® Developer's Guide (Paperback)

The book contains a nice balance of guidelines and tips coupled w commonly used reference material. A nice to have close by when developing w MS SQL. Good for DBA and programmer/ developer.