Pro SQL Server 2019 Administration: A Guide for the Modern DBA ,2e

Peter A. Carter

  • 出版商: Apress
  • 出版日期: 2019-10-19
  • 售價: $2,450
  • 貴賓價: 9.5$2,328
  • 語言: 英文
  • 頁數: 952
  • 裝訂: Paperback
  • ISBN: 1484250885
  • ISBN-13: 9781484250884
  • 相關分類: MSSQLSQL
  • 無法訂購
    無現貨庫存(No stock available)



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資料庫管理員的參考,涵蓋了實踐中需要了解的所有內容,以完成日常工作。此版本已更新至SQL Server 2019,包括了新功能的介紹,例如Memory-optimized TempDB Metadata和Always Encrypted with Secure Enclaves。其他新增內容包括了Query Store、可恢復的索引操作、在Linux上的安裝以及容器化的SQL。

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

本書教授如何充分利用SQL Server 2019的新功能,包括資料發現和分類。書中提倡最佳實踐的安裝方式,展示如何進行可擴展性和高工作負載的配置,並演示了一系列資料庫層級的維護任務,如索引維護、資料庫一致性檢查和表優化。


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


- 管理SQL Server本地安裝的SQL Server DBAs。本書也適用於希望學習高級功能,如Query Store、Extended Events、Distributed Replay和基於策略的管理的DBAs,或者需要在各種環境中安裝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是一位擁有超過15年經驗的SQL Server專家,擅長開發、管理和架構SQL Server平台和數據層應用。他在2011年獲得了微軟的MCC認證,並擁有從2005年版本開始的一系列MCTS、MCITP、MCSA和MCSE SQL Server認證。Peter撰寫了多本關於各種SQL Server主題的書籍,包括安全性、高可用性和自動化。