Microsoft SQL Server 2005: Applied Techniques Step by Step (Paperback)

Description

Take your database skills to the next level with this hands-on, step-by-step guide.

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

Includes a CD featuring:
•All practice exercises
•Code samples

描述

以這本實踐式、逐步指南，將您的資料庫技能提升到更高的水平。

透過這個逐步學習的教程，您將學習更進階的技巧，以一步一步的方式設計、建立、測試、部署和維護 SQL Server 資料庫。適合已經了解資料庫基礎的開發人員，本教程提供實用的指導、程式碼範例和一系列技巧，幫助您解決真實世界的業務問題。

探索如何：
- 透過伺服器登入、使用者和伺服器角色來管理資料存取權限
- 實施災難恢復策略
- 使用聚合函數計算總和和複雜統計值
- 透過管理 IO 統計資料和設計索引來優化查詢效能
- 與遠端資料來源（包括第三方資料庫）一起工作
- 透過網際網路或中間層服務介面提供遠端存取
- 管理交易、實施錯誤處理程序和定義隔離層級
- 進一步使用 SQL Server Reporting Services 和 Notification Services

附帶光碟包含：
- 所有練習題
- 程式碼範例