Microsoft SQL Server 2008 Management and Administration (Paperback)
暫譯: Microsoft SQL Server 2008 管理與行政

Ross Mistry

  • 出版商: SAMS
  • 出版日期: 2009-01-02
  • 售價: $1,710
  • 貴賓價: 9.5$1,625
  • 語言: 英文
  • 頁數: 912
  • 裝訂: Paperback
  • ISBN: 067233044X
  • ISBN-13: 9780672330445
  • 相關分類: MSSQLSQL
  • 已過版

買這商品的人也買了...

商品描述

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

 

Understand how to:
  •          Master DBA tips, tricks, and best practices proven in actual enterprise environments
  •          Install, upgrade or transition to SQL Server 2008.
  •          Harden and Secure an implementation.
  •          Encrypt SQL Server from an end-to-end perspective.
  •          Implement high availability–and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring
  •          Save time with SQL Server 2008’s new policy-based management tools
  •          Performance tune and troubleshoot a SQL Server 2008 environment.
  •          Optimize application performance and manage workloads with the powerful new Resource Governor
  •          Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more…
Bonus Content:
  •          The book is based on Windows Server 2008
  •          Step by step instructions of how to implement a failover cluster on Windows Server 2008
  •          SQL Server PoweShell Administration Tasks
  •          Consolidate and virtualize SQL Server with Hyper-V
  •          Step by step instructions on how to install Hyper-V
  •          Proactively Monitor SQL Server with Operations Manager
  •          Install Windows Server 2008 certificates to encrypt SQL Server data
Contributing Writers include:

Hilary Cotter — SQL Server MVP

John Welch — SQL Server MVP

Marco Shaw — PowerShell MVP

Maciej Pilecki — SQL Server MVP

Shirmattie Seenarine — Technical Writer

商品描述(中文翻譯)

如果您需要部署、管理或保護 Microsoft SQL Server 2008,這是您一直在尋找的完整、快速且以任務為基礎的參考書。這本書由一位在企業中擁有世界級專業知識的 SQL Server 專家撰寫,內容遠超過基本知識,涵蓋了資料庫管理員 (DBA) 需要掌握的複雜任務,以充分利用 Microsoft 的旗艦資料庫平台。SQL Server MVP Ross Mistry 提供了經過驗證的 SQL Server 2008 安裝、升級、備份/還原、資料傳輸、索引、高可用性、安全性等技術,還有更多內容。他基於在高知名度的生產環境中的廣泛測試,提供逐步解決方案和強大的技巧,這些技巧在其他地方無法找到。每一章都以一節開始,介紹 SQL Server 2008 最重要的新改進,並以方便的最佳實踐摘要結束。每一章還概述了利用 Windows Server 2008 的好處。

了解如何:
- 掌握在實際企業環境中經過驗證的 DBA 提示、技巧和最佳實踐
- 安裝、升級或過渡到 SQL Server 2008
- 加強和保護實作
- 從端到端的角度加密 SQL Server
- 實施高可用性,並利用 SQL Server 2008 在故障轉移叢集和資料庫鏡像方面的重大改進
- 使用 SQL Server 2008 的新政策管理工具節省時間
- 調整性能並排除 SQL Server 2008 環境中的故障
- 優化應用程式性能並使用強大的新資源管理器管理工作負載
- 實施性能工作室、維護計劃、透明資料加密等更多內容…

附加內容:
- 本書基於 Windows Server 2008
- 如何在 Windows Server 2008 上實施故障轉移叢集的逐步指導
- SQL Server PowerShell 管理任務
- 使用 Hyper-V 整合和虛擬化 SQL Server
- 如何安裝 Hyper-V 的逐步指導
- 使用 Operations Manager 主動監控 SQL Server
- 安裝 Windows Server 2008 證書以加密 SQL Server 資料

貢獻作者包括:
Hilary Cotter — SQL Server MVP
John Welch — SQL Server MVP
Marco Shaw — PowerShell MVP
Maciej Pilecki — SQL Server MVP
Shirmattie Seenarine — 技術作家