Microsoft SQL Server(TM) 2005

Description

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.

First Sentence

With the advent of better performing and more flexible database engines like the one on Microsoft SQL Server 2005, the line is blurring between what should be stored in a database and what should not.

Subjects

Other Editions

• Microsoft SQL Server(TM) 2005: Applied Techniques Step by Step (Pro - Step By Step Developer)PaperbackMicrosoft Press2006-06-21
• Microsoft SQL Server(TM) 2005PaperbackMicrosoft Press2006-09-13
• Microsoft® SQL Server™ 2005Electronic resourceMicrosoft Press2007-01-01
• Microsoft® SQL Server™ 2005Electronic resourceMicrosoft Press2007-01-01