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 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