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
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.
Table of Contents
PART I: SQL Server 7 Environment.
Chapter 1: Introduction to Microsoft SQL Server 7.
Chapter 2: The MS-SQL Server Environment.
PART II: Database Administration for the Developer.
Chapter 3: SQL Server 7 Common Administration.
Chapter 4: SQL Server 7 Tools and Components.
Chapter 5: DBMS Administration Tasks.
Chapter 6: Database Administration Using Enterprise Manager.
PART III: SQL Server 7 Application Development.
Chapter 7: Setting Up the Development Environment.
Chapter 8: Overview of the Application Development Process.
Chapter 9: Defining the Application.
Chapter 10: Designing the Application.
Chapter 11: Constructing the Database.
Chapter 12: Manipulating Data.
Chapter 13: Developing the User Interface.
Chapter 14: Tuning Your Environment.
Chapter 15: Debugging.
PART IV: Programming Languages and Tools.
Chapter 16: Stored Procedures.
Chapter 17: C and Java with SQL.
Appendix A: Third-party Tools.
Appendix B: Standards, Guidelines, and Maxims.