Pro SQL Server Internals
暫譯: 專業 SQL Server 內部原理

Dmitri Korotkevitch

Pro SQL Server Internals
  • 出版商: Apress
  • 出版日期: 2016-12-01
  • 定價: $3,150
  • 售價: 8.0 折 $2,520
  • 語言: 英文
  • 頁數: 804
  • 裝訂: Paperback
  • ISBN: 1484219635
  • ISBN-13: 9781484219638
  • 相關分類: MSSQL、SQL

    • 立即出貨 (庫存 < 3)

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

商品描述

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 的內部結構，包括 In-Memory OLTP、列存儲增強、操作分析支持、查詢存儲、JSON、時間表、伸展數據庫、安全功能以及新版本 SQL Server 的其他改進。這些知識也可以應用於與 SQL Server 2016 共享相同代碼的 Microsoft Azure SQL 數據庫。

 

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

• 提供有關新 SQL Server 2016 功能和增強的詳細知識

• 包含重新整理的列存儲索引和 In-Memory OLTP 的內容

• 涵蓋索引和交易策略

• 展示各種數據庫對象和技術的內部實現，以及何時應該或不應該使用它們

• 演示 SQL Server 如何執行查詢以及如何處理數據和交易日誌

 


您將學到什麼

 

 


  • 使用 SQL Server 設計和開發數據庫解決方案。

  • 排除設計、併發和性能問題。

  • 為工作選擇合適的數據庫對象和技術。

  • 降低成本，提高可用性和可管理性。

  • 設計災難恢復和高可用性策略。

  • 通過 In-Memory OLTP 和列存儲索引提高 OLTP 和數據倉庫系統的性能。

 

 

本書適合誰

希望以充分利用 SQL Server 的方式設計、開發和維護系統的開發人員和數據庫管理員。本書非常適合那些喜歡理解和解決問題根本原因，而不是僅僅對其進行「貼補」的人。

類似商品

最後瀏覽商品 (12)