SQL Server 2014 with PowerShell v5 Cookbook

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

SQL Server 2014 with PowerShell v5 Cookbook

Donabel Santos

6 customer reviews
Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity
Mapt Subscription
FREE
$30.00/m after trial
eBook
$33.60
RRP $47.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$33.60
$59.99
$29.99 p/m after trial
RRP $47.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


SQL Server 2014 with PowerShell v5 Cookbook Book Cover
SQL Server 2014 with PowerShell v5 Cookbook
$ 47.99
$ 33.60
SQL Server 2016 Developer's Guide Book Cover
SQL Server 2016 Developer's Guide
$ 47.99
$ 33.60
Buy 2 for $35.00
Save $60.98
Add to Cart

Book Details

ISBN 139781785283321
Paperback760 pages

Book Description

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.

Table of Contents

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

Authors

Table of Contents

Book Details

ISBN 139781785283321
Paperback760 pages
Read More
From 6 reviews

Read More Reviews

Recommended for You

SQL Server 2016 Developer's Guide Book Cover
SQL Server 2016 Developer's Guide
$ 47.99
$ 33.60
SQL Server 2017 Integration Services Cookbook Book Cover
SQL Server 2017 Integration Services Cookbook
$ 47.99
$ 33.60
Windows Server 2016 Automation with PowerShell Cookbook - Second Edition Book Cover
Windows Server 2016 Automation with PowerShell Cookbook - Second Edition
$ 47.99
$ 33.60
Mastering Windows PowerShell Scripting - Second Edition Book Cover
Mastering Windows PowerShell Scripting - Second Edition
$ 35.99
$ 25.20
SQL Server 2016 Reporting Services Cookbook Book Cover
SQL Server 2016 Reporting Services Cookbook
$ 43.99
$ 30.80
SQL Server 2017 Administrator's Guide Book Cover
SQL Server 2017 Administrator's Guide
$ 43.99
$ 30.80