Pro SQL Server Internals

Dmitri Korotkevitch

  • 出版商: Apress
  • 出版日期: 2016-12-01
  • 售價: $2,700
  • 貴賓價: 9.5$2,565
  • 語言: 英文
  • 頁數: 804
  • 裝訂: Paperback
  • ISBN: 1484219635
  • ISBN-13: 9781484219638
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存=1)

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

商品描述

Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You’ll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems.

New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016.

 

Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book:
• Provides detailed knowledge of new SQL Server 2016 features and enhancements
• Includes revamped coverage of columnstore indexes and In-Memory OLTP
• Covers indexing and transaction strategies
• Shows how various database objects and technologies are implemented internally, and when they should or should not be used
• Demonstrates how SQL Server executes queries and works with data and transaction log

 

What You Will Learn

 

 

  • Design and develop database solutions with SQL Server.
  • Troubleshoot design, concurrency, and performance issues.
  • Choose the right database objects and technologies for the job.
  • Reduce costs and improve availability and manageability.
  • Design disaster recovery and high-availability strategies.
  • Improve performance of OLTP and data warehouse systems through in-memory OLTP and Columnstore indexes.

 

 

Who This Book Is For

Developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem rather than applying a 'band aid' to it.

商品描述(中文翻譯)

提升您開發、管理和疑難排解 SQL Server 解決方案的能力,學習不同組件如何在幕後運作,以及它們如何彼此通信。詳細的知識有助於實施和維護對您的業務和客戶至關重要的高吞吐量數據庫。您將學習如何識別每個問題的根本原因,並了解不同的設計和實施決策如何影響系統的性能。

本第二版新增了對 SQL Server 2016 內部結構的覆蓋,包括內存 OLTP、列存優化、操作分析支持、查詢存儲、JSON、時間表、彈性數據庫、安全功能以及新版 SQL Server 的其他改進。這些知識也可應用於與 SQL Server 2016 共享相同代碼的 Microsoft Azure SQL 數據庫。

《Pro SQL Server Internals》是一本針對開發人員和數據庫管理員的書籍,涵蓋了從 SQL Server 2005 開始一直到最近發布的 SQL Server 2016 的多個版本。本書提供了一個深入了解 SQL Server 數據庫服務器的深度和功能的路線圖,並教授如何充分利用該平台,使您的數據庫運行在支持業務所需的水平上。本書:

- 提供了對新 SQL Server 2016 功能和改進的詳細了解
- 包括對列存優化和內存 OLTP 的重新覆蓋
- 講解索引和事務策略
- 展示了各種數據庫對象和技術的內部實現方式,以及何時應該或不應該使用它們
- 演示了 SQL Server 如何執行查詢並處理數據和事務日誌

《Pro SQL Server Internals》還介紹了以下內容:

- 設計和開發使用 SQL Server 的數據庫解決方案
- 疑難排解設計、並發性和性能問題
- 選擇適合的數據庫對象和技術
- 降低成本,提高可用性和可管理性
- 設計災難恢復和高可用性策略
- 通過內存 OLTP 和列存優化提高 OLTP 和數據倉庫系統的性能

本書適合開發人員和數據庫管理員,他們希望以能夠理解和解決問題根本原因的方式設計、開發和維護系統,而不僅僅是對其進行臨時修補。