Microsoft SQL Server(TM) 2005

A skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005. Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases—one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems. Discover how to:Manage data access with server logins and user and server rolesImplement a disaster recovery strategy Use aggregate functions to compute totals and complex statistical valuesOptimize query performance by managing IO statistics and designing indexes Work with remote data sources—including third-party databasesProvide remote access through the Internet or a middle-tier service interface Manage transactions, implement error handlers, and define isolation levelsGo further and work with SQL Server Reporting Services and Notification ServicesThe CD that accompanies the print edition of this book is not available with its eBook edition, although select CD content is available for download. A link to the content is included in your eBook.