Pro SQL Server 2019 Administration: A Guide for the Modern DBA ,2e
暫譯: 專業 SQL Server 2019 管理：現代 DBA 指南，第二版

Peter A. Carter

Pro SQL Server 2019 Administration: A Guide for the Modern DBA ,2e
  • 出版商: Apress
  • 出版日期: 2019-10-19
  • 售價: $2,230
  • 貴賓價: 9.5 折 $2,119
  • 語言: 英文
  • 頁數: 952
  • 裝訂: Paperback
  • ISBN: 1484250885
  • ISBN-13: 9781484250884
  • 相關分類: MSSQL、SQL

    • 海外代購書籍(需單獨結帳)

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

相關主題

商品描述

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL.

 

Pro SQL Server 2019 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Finally, readers will learn how to perform advanced maintenance and tuning techniques.

 

This book teaches you to make the most of new SQL Server 2019 functionality, including Data Discovery and Classification. The book promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations. 

 

 

What You Will Learn

  • Install and configure SQL Server on Windows through the GUI and with PowerShell 
  • Install and configure SQL Server on Linux and in Containers
  • Optimize tables through in-memory OLTP, table partitioning, and the creation of indexes
  • Secure and encrypt data to protect against embarrassing data breaches
  • Ensure 24x7x365 access through high-availability and disaster recovery features
  • Back up your data to ensure against loss, and recover data when needed
  • Perform routine maintenance tasks such as database consistency checks  
  • Troubleshoot and solve performance problems in SQL queries and in the database engine

 

Who This Book Is For

 

SQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features such as Query Store, Extended Events, Distributed Replay, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.

商品描述(中文翻譯)

使用這本全面的 SQL Server DBA 指南，涵蓋所有實務資料庫管理員需要知道的內容，以完成日常工作。本書已更新至 SQL Server 2019 版本，包括新功能的介紹，如記憶體優化的 TempDB 元資料，以及使用安全區域的 Always Encrypted。其他新內容包括查詢儲存(Query Store)、可恢復的索引操作、在 Linux 上的安裝，以及容器化的 SQL。

《Pro SQL Server 2019 Administration》帶領 DBA 開始一段旅程，從規劃 SQL Server 部署開始，經過安裝和配置實例、管理和優化資料庫物件，確保資料安全且高度可用。最後，讀者將學習如何執行進階的維護和調優技術。

本書教你充分利用 SQL Server 2019 的新功能，包括資料發現和分類。書中推廣最佳實踐的安裝，展示如何配置以實現可擴展性和高工作負載，並演示各種資料庫層級的維護任務，如索引維護、資料庫一致性檢查和表優化。

你將學到的內容：

- 通過 GUI 和 PowerShell 在 Windows 上安裝和配置 SQL Server
- 在 Linux 和容器中安裝和配置 SQL Server
- 通過記憶體內 OLTP、表分割和索引創建來優化表
- 確保資料安全和加密，以防止尷尬的資料洩漏
- 通過高可用性和災難恢復功能確保 24x7x365 的訪問
- 備份資料以防止損失，並在需要時恢復資料
- 執行例行維護任務，如資料庫一致性檢查
- 排除 SQL 查詢和資料庫引擎中的性能問題

本書適合對象：

管理本地安裝 SQL Server 的 SQL Server DBA。本書對於希望學習進階功能的 DBA 也很有用，如查詢儲存(Query Store)、擴展事件(Extended Events)、分散式重放(Distributed Replay)和基於政策的管理(Policy-Based Management)，或需要在各種環境中安裝 SQL Server 的人。

作者簡介

Peter Carter is a SQL Server expert with over 15 years of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.

作者簡介(中文翻譯)

彼得·卡特（Peter Carter）是一位 SQL Server 專家，擁有超過 15 年的經驗，專注於開發、管理和架構 SQL Server 平台及數據層應用程式。他於 2011 年獲得微軟頒發的 MCC，並擁有一系列 SQL Server 的 MCTS、MCITP、MCSA 和 MCSE 認證，涵蓋從 2005 版本開始的各個版本。彼得撰寫了多本有關 SQL Server 的書籍，主題包括安全性、高可用性和自動化。

類似商品