精通 SQL Server 2008 Mastering Sql Server 2008

基本信息

Format:Paperback / softback 792 pages

Publisher:John Wiley & Sons Inc

Imprint:Sybex Inc.,U.S.

ISBN:9780470289044

Published:16 Jan 2009

Weight:1146g

Dimensions:234 x 189 (mm)

信息仅供参考，具体请以实物为准

书籍简介

作为 Microsoft 畅销的数据库管理器，SQL Server 具有高度灵活性和可定制性，并且具有出色的支持 — 2008 版本提供了几个重要的新功能。本书准确而专业地介绍了 SQL Server 2008 的更新，例如其增强的安全性；无需更改应用程序即可加密整个数据库、数据文件和日志文件的能力；可管理任何规模和复杂程度的报告和分析的可扩展基础结构；以及其广泛的性能数据收集。

As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

作者简介

Michael Lee，MCT、MCITP、MCPD、SCJP，自 1995 年以来一直教授 SQL Server。在过去的 13 年里，Michael 为美国和欧洲的公司提供 SQL Server 和企业数据架构方面的培训和咨询服务。Gentry Bieker，MCT、MCITP、MCDBA、MCSE，自 1998 年以来一直担任顾问、导师和培训师。他从 6.0 版开始就一直在设计、开发和管理 SQL Server 数据库。

Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995. Over the last 13 years, Michael has provided trainingand consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Gentry Bieker, MCT, MCITP, MCDBA, MCSE, has been a consultant, mentor, and trainer since 1998. He has been architecting, developing, and administering SQL Server databases since version 6.0.

部分目录，仅供参考

1. Overview of Microsoft SQL Server 2008.

2. Understanding SQL Server Architecture.

3. Databases, Files, and Resource Management.

4. Tables and CRUD Operations.

5. Procedural programming.

6. Managing Data Integrity.

7. SQL Server and XML.

8. Managing User Security.

9. Data Recovery.

10. Monitoring SQL Server Activity.

11. Using the SQL Server Agent Service.

12. Data Availability and Distribution.

13. SQL Server Data Security.

14. Indexing Strategies for Query Optimization.

15. Transactions and Locking Strategies.

16. Using Resource Governor and Policy-Based Management.

17. SQL Server and the .NET Client.

18. Leveraging the SQL Server .NET CLR.

19. Using Spatial Data.

20. Service Oriented Architecture and the Service Broker.

21. Full Text Search Services.