Expert Scripting and Automation for SQL Server DBAs: Amplifying Productivity Through Automation
暫譯: SQL Server DBA 專家腳本與自動化：透過自動化提升生產力
Carter, Peter A.
相關主題
商品描述
The market is trending toward a much smaller ratio of DBAs to SQL Server instances, but this book will help you meet this new reality by harnessing automation to continue building and maintaining reliable database platform services for your SQL Server enterprise. The book will help you automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with the power of PowerShell. You'll soon be able to automate your new instance-builds and centralize your maintenance.
This book walks you through automating the SQL Server build processes and maintenance of multiple instances from a single location, as well as how to use database metadata to drive your automation. With a heavier focus on PowerShell, this 2nd edition highlights modern techniques, such as configuration management. Also new in this edition, you will learn how to use PowerShell modules such as SqlServer and DBATools, which is a popular community module that you can rely on to keep your database estate running smoothly. You will understand the benefits of centralizing maintenance to better keep your enterprise responding with reliable performance to the loads placed upon it by your business. The book helps you become faster and better at what you do for a living, and thus will boost your value within the job market.
What You Will Learn
- Automate SQL Server installation and configuration
- Apply techniques such as Desired State Configuration to prevent drift on your servers and instances
- Increase your value to your organization by automating low-value tasks and focusing your time on the higher-value ones
- Take advantage of database metadata to drive automation, allowing you to build intelligent automated routines
- Promote and demonstrate how to modernize database maintenance across your enterprise
- Apply tools such as PowerShell with modern techniques to increase your value in the job market
Who This Book Is For
SQL Server DBAs who want to increase their productivity by embracing automation
商品描述(中文翻譯)
市場趨勢顯示，資料庫管理員（DBA）與 SQL Server 實例的比例正在變得越來越小，但本書將幫助您適應這一新現實，通過利用自動化來持續構建和維護可靠的資料庫平台服務，以支持您的 SQL Server 企業。本書將幫助您自動化工作負載，並更輕鬆高效地管理更多的資料庫和實例，通過結合以元數據驅動的自動化與 PowerShell 的強大功能。您將能夠自動化新的實例建置並集中管理維護。
本書將指導您如何從單一位置自動化 SQL Server 的建置過程和多個實例的維護，以及如何使用資料庫元數據來驅動您的自動化。第二版更重視 PowerShell，突顯現代技術，例如配置管理。此外，在本版中，您將學習如何使用 PowerShell 模組，如 SqlServer 和 DBATools，這是一個受歡迎的社群模組，您可以依賴它來保持您的資料庫環境運行順利。您將了解集中維護的好處，以便更好地讓您的企業對業務所施加的負載做出可靠的反應。本書幫助您在職業生涯中變得更快、更好，從而提升您在就業市場中的價值。
您將學到的內容：
- 自動化 SQL Server 的安裝和配置
- 應用如期望狀態配置（Desired State Configuration）等技術，以防止伺服器和實例的漂移
- 通過自動化低價值任務來提高您對組織的價值，並將時間集中在高價值任務上
- 利用資料庫元數據來驅動自動化，使您能夠構建智能自動化例程
- 推廣並展示如何在整個企業中現代化資料庫維護
- 應用如 PowerShell 等工具，結合現代技術來提高您在就業市場中的價值
本書適合對象：
希望通過擁抱自動化來提高生產力的 SQL Server DBA。
作者簡介
Peter Carter is a SQL Server expert with two decades of experience developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and currently leads a team of platform engineers within a major UK company. His passion for SQL Server shows through in everything he does, and has written a number of SQL Server books (Apress), including Pro SQL Server 2022 Administration, SQL Server Advanced Data Types, Securing SQL Server, and SQL Server 2019 AlwaysOn.
作者簡介(中文翻譯)
彼得·卡特是一位擁有二十年經驗的 SQL Server 專家，專注於開發、管理和架構 SQL Server 平台及數據層應用程式。彼得於 2011 年獲得微軟頒發的 MCC，目前在一家英國大型公司領導一支平台工程師團隊。他對 SQL Server 的熱情體現在他所做的每一件事上，並且撰寫了多本 SQL Server 書籍（Apress），包括 Pro SQL Server 2022 Administration、SQL Server Advanced Data Types、Securing SQL Server 和 SQL Server 2019 AlwaysOn。
