PowerShell for SQL Server Essentials
| By: | Donabel Santos |
| Publisher: | Packt Publishing |
| Print ISBN: | 9781784391492 |
| eText ISBN: | 9781784397104 |
| Edition: | 1 |
| Copyright: | 2015 |
| Format: | Reflowable |
Lifetime - $23.99
eBook Features
Instant Access
Purchase and read your book immediately
Read Offline
Access your eTextbook anytime and anywhere
Study Tools
Built-in study tools like highlights and more
Read Aloud
Listen and follow along as Bookshelf reads to you
Details
Table of Contents
Book Description
This book is written for SQL Server administrators and developers who want to leverage PowerShell to work with SQL Server. Some background with scripting will be helpful but not necessary.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 snapins
- 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 TSQL queries from PowerShell and export results
- Accomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShell