In this chapter, we tackle a variety of recipes that are not SQL Server-specific; but you may find them useful as you use PowerShell with SQL Server. Often, you will need to compress (or zip) files, create timestamped files, analyze event logs for recent system errors, export a list of processes to CSV or XML, or even access web services. Here, you will find code snippets that you can use in existing or new scripts, or whenever you need them.
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