SQL Server 2014 with PowerShell v5 Cookbook Paperback – December 4, 2015

Donabel Santos

  • 出版商: Packt Publishing
  • 出版日期: 2015-11-30
  • 售價: $2,530
  • 貴賓價: 9.5$2,404
  • 語言: 英文
  • 頁數: 760
  • 裝訂: Paperback
  • ISBN: 1785283324
  • ISBN-13: 9781785283321
  • 相關分類: MSSQLPowershellSQL
  • 海外代購書籍(需單獨結帳)

商品描述

Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity

About This Book

  • This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex scripts for your day-to-day job
  • The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components
  • It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell

Who This Book Is For

If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of scripting would be helpful, but it is not necessary.

What You Will Learn

  • Explore database objects and execute queries on multiple servers
  • Manage and monitor the running of SQL Server services and accounts
  • Back up and restore databases
  • Create an inventory of database properties and server configuration settings
  • Maintain permissions and security for users
  • Work with CLR assemblies, XML, and BLOB objects in SQL
  • Manage and deploy SSIS packages and SSRS reports

In Detail

PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components.

The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON.

Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers. Towards the end of the book, you will find some useful information, which includes a PowerShell tutorial for novice users, some commonly-used PowerShell and SQL Server syntax, and a few online resources. Finally, you will create your own SQL Server Sandbox VMs. All these concepts will help you to efficiently manage your administration tasks.

Style and approach

SQL Server 2014 with PowerShell v5 Cookbook is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away.

You can read this book sequentially by chapter or you can pick and choose which topics you need right away.

商品描述(中文翻譯)

超過150個真實案例,簡化資料庫管理、自動化重複任務並提升工作效率的食譜。

關於本書:
- 本書幫助您建立堅實的基礎,讓您能夠熟練地使用 PowerShell 與 SQL Server,讓您能夠為日常工作創建更複雜的腳本。
- 本書提供了許多指南、技巧和解釋,告訴您何時以及如何使用 PowerShell cmdlets、WMI、SMO、.NET 類別或其他元件。
- 本書提供易於遵循的實用食譜,幫助您充分利用 SQL Server 和 PowerShell。

本書適合對象:
- 如果您是 SQL Server 資料庫專業人員(DBA、開發人員或 BI 開發人員),希望使用 PowerShell 自動化、整合和簡化資料庫任務,那麼本書適合您。具備腳本撰寫知識將有所幫助,但不是必需的。

您將學到什麼:
- 探索資料庫物件並在多個伺服器上執行查詢。
- 管理和監控 SQL Server 服務和帳戶的運行。
- 備份和還原資料庫。
- 建立資料庫屬性和伺服器配置設定清單。
- 維護使用者的權限和安全性。
- 在 SQL 中使用 CLR 組件、XML 和 BLOB 物件。
- 管理和部署 SSIS 封裝和 SSRS 報表。

詳細內容:
PowerShell 可用於自動化和簡化 SQL Server 任務。PowerShell 具有豐富的 cmdlets,並與 .NET 框架緊密集成。其腳本功能強大且靈活,可讓您簡化不同 Microsoft 應用程式和元件之間的自動化和整合。

本書首先介紹 SQL Server 2014 和 PowerShell v5 的新功能,以及 SQL Server 的安裝。您將學習基本的 SQL Server 管理任務,然後了解一些與安全相關的主題,如身份驗證模式和分配權限。接著,您將探索不同的方法來備份和還原資料庫,並執行高級管理任務,如使用策略、檔案表和 SQL 審核。本書的下一部分涵蓋了更高級的 HADR 任務,如日誌傳送和資料鏡像,然後向您展示如何開發伺服器以處理 BLOB、XML 和 JSON。

接著,您將了解 SQL Server 的 BI 堆疊,包括 SSRS 報表、SSIS 封裝和 SSAS cmdlet 和資料庫。不特定於 SQL Server 的程式碼片段將幫助您快速在 SQL 伺服器上執行任務。在本書的最後,您將找到一些有用的資訊,包括針對新手使用者的 PowerShell 教程、一些常用的 PowerShell 和 SQL Server 語法,以及一些線上資源。最後,您將建立自己的 SQL Server Sandbox VM。所有這些概念將幫助您有效地管理管理任務。

風格和方法:
《SQL Server 2014 with PowerShell v5 Cookbook》是一本以實例為重點的書籍,提供了逐步指示,教您如何使用 PowerShell 完成特定的 SQL Server 任務。每個食譜後面都有對所採取的步驟或設計決策的分析,以及有關當前任務的其他資訊。所有示例都提供了可立即使用的工作腳本。您可以按章節順序閱讀本書,也可以選擇您需要的主題。