9780764546723

Summary

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

Author Biography

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.

Preface

Acknowledgments

xiii

Part I: SQL Server 7 Environment

Introduction to Microsoft SQL Server 7

(12)

The MS-SQL Server Environment

(26)

Part II: Database Administration for the Developer

SQL Server 7 Common Administration

(20)

SQL Server 7 Tools and Components

(54)

DBMS Administration Tasks

115

(24)

Database Administration Using Enterprise Manager

139

(28)

Part III: SQL Server 7 Application Development

Setting Up the Development Environment

167

(20)

Overview of the Application Development Process

187

(30)

Defining the Application

217

(18)

Designing the Application

235

(12)

Constructing the Database

247

(54)

Manipulating Data

301

(54)

Developing the User Interface

355

(14)

Tuning Your Environment

369

(28)

Debugging

397

(32)

Part IV: Programming Languages and Tools

Stored Procedures

429

(44)

C and Java with SQL

473

(40)

Appendix A: Third-party Tools

513

(10)

Appendix B: Standards, Guidelines, and Maxims

523

(32)

Index

555

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.