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