SQL Server 2014 with Powershell v5 Cookbook

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

Publisher:Packt Publishing Limited

By: Donabel Santos

Paid access

|Sep 2025

E-Book €39.99Institutions €139.95

Key Features

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.

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

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.

Getting Started with SQL Server and PowerShell
SQL Server and PowerShell Basic Tasks
Basic Administration
Security
Backup and Restore
Advanced Administration
Audit & Policies
High Availability
SQL Server Development
Business Intelligence
Non SQL Server Specific but All Around Helpful Snippets
Appendix A: PowerShell Primer
Appendix B:Creating SQL Server Sandbox VMs

https://github.com/packtpublishing/sql-server-2014-with-powershell-v5-cookbook

PDF ISBN: 978-1-78528-361-1

Publisher: Packt Publishing Limited

Publication date: 2025

Language: English

Pages: 760

SQL Server 2014 with Powershell v5 Cookbook

Key Features

Book Description

What you will learn

Who this book is for

Table of Contents

People also read

Publications carousel

SQL Server 2012 with PowerShell V3 Cookbook

PowerShell for SQL Server Essentials

Getting Started with SQL Server 2014 Administration

SQL Server 2017 Administrator's Guide

PowerShell Essential Guide

SQL Server 2014 Development Essentials

Powershell Core 6.2 Cookbook

SQL Server 2016 Developer's Guide

Windows Server 2016 Automation with PowerShell Cookbook

Windows Server Automation with PowerShell Cookbook

Paradigm

My account