In this chapter, we will tackle more administrative tasks that can be accomplished using PowerShell. PowerShell can help automate a lot of the repetitive, tedious, mundane tasks that used to take so many clicks to accomplish. Some of the tasks we will look at include checking disk space, checking instance and database properties, creating WMI alerts, and managing SQL Server jobs.
SQL Server 2014 with PowerShell v5 Cookbook
By :
SQL Server 2014 with PowerShell v5 Cookbook
By:
Overview of this book
Table of Contents (21 chapters)
SQL Server 2014 with PowerShell v5 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Getting Started with SQL Server and PowerShell
SQL Server and PowerShell Basic Tasks
Basic Administration
Security
Backup and Restore
Advanced Administration
Audit and Policies
High Availability with AlwaysOn
SQL Server Development
Business Intelligence
Helpful PowerShell Snippets
PowerShell Primer
Creating a SQL Server VM
Index
Customer Reviews