PowerShell for SQL Server Essentials

Manage and monitor SQL Server administration and application deployment with PowerShell

PowerShell for SQL Server Essentials

Donabel Santos

3 customer reviews
Manage and monitor SQL Server administration and application deployment with PowerShell
Packt Subscription
FREE
$9.99/m after trial
eBook
$7.20
RRP $17.99
Save 59%
Print + eBook
$29.99
RRP $29.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
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
$7.20
$29.99
$9.99 p/m after trial
RRP $17.99
RRP $29.99
Subscription
eBook
Print + eBook
Start a FREE 10-day trial

Frequently bought together


PowerShell for SQL Server Essentials Book Cover
PowerShell for SQL Server Essentials
$ 17.99
$ 7.20
SQL Server 2014 with PowerShell v5 Cookbook Book Cover
SQL Server 2014 with PowerShell v5 Cookbook
$ 47.99
$ 19.20
Buy 2 for $26.40
Save $39.58
Add to Cart

Book Details

ISBN 139781784391492
Paperback186 pages

Book Description

PowerShell for SQL Server Essentials helps us to manage and monitor server administration and application deployment. Use PowerShell along with SQL Server to perform common DBA tasks.

Starting with a basic introduction to PowerShell, the initial chapters will provide the SQL Server professional PowerShell fundamentals, covering topics such as PowerShell notations and syntax, cmdlets, pipeline, and getting help. Succeeding chapters build upon these fundamentals, and illustrate how to administer and automate SQL Server. Tasks covered throughout include profiling the SQL Server instance, performing backup and restores, invoking T-SQL scripts using PowerShell, and monitoring jobs, security, and permissions.

Packed with practical examples and numerous ready-to-use snippets, this book gets you to an intermediate level in using PowerShell for SQL Server.

What You Will Learn

  • Create scripts using PowerShell to manage and monitor server administration and application deployment
  • Automate the creation of SQL Database objects through PowerShell with the help of the SQL Server module (SQLPS) and SQL Server snap-ins
  • Use PowerShell to work with SQL Server specific providers and cmdlets
  • Identify and manage SQL Server services, instances, settings, and confi gurations
  • Profile your SQL Server instances and export current configurations to a file
  • Monitor SQL Server jobs and alerts
  • Manage logins, database users, and instance security and permissions
  • Invoke T-SQL queries from PowerShell and export results
  • Accomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShell

Authors

Book Details

ISBN 139781784391492
Paperback186 pages
Read More
From 3 reviews

Read More Reviews

Recommended for You

SQL Server 2014 with PowerShell v5 Cookbook Book Cover
SQL Server 2014 with PowerShell v5 Cookbook
$ 47.99
$ 19.20
SQL Server 2016 Developer's Guide Book Cover
SQL Server 2016 Developer's Guide
$ 47.99
$ 19.20
Mastering Windows PowerShell Scripting - Second Edition Book Cover
Mastering Windows PowerShell Scripting - Second Edition
$ 35.99
$ 14.40
SQL Server 2017 Integration Services Cookbook Book Cover
SQL Server 2017 Integration Services Cookbook
$ 47.99
$ 19.20
SQL Server 2017 Administrator's Guide Book Cover
SQL Server 2017 Administrator's Guide
$ 43.99
$ 17.60
PowerShell: Automating Administrative Tasks Book Cover
PowerShell: Automating Administrative Tasks
$ 67.99
$ 27.20