Publisher's Synopsis
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
