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
Preface.
Acknowledgments.
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.
Index.
Overview
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 ...