Microsoft® SQL Server™ 2005: Applied Techniques Step by Step



Microsoft® SQL Server™ 2005: Applied Techniques Step by Step
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 roles
Implement a disaster recovery strategy
Use aggregate functions to compute totals and complex statistical values
Optimize query performance by managing IO statistics and designing indexes
Work with remote data sources—including third-party databases
Provide remote access through the Internet or a middle-tier service interface
Manage transactions, implement error handlers, and define isolation levels
Go further and work with SQL Server Reporting Services and Notification Services
No Other Mirrors, Please!

Keep2Share