PowerShell can help database administrators and developers to automate security tasks. Whether you need to monitor repeated failed login attempts by parsing out event logs, or manage roles and permissions when the number of users in the system is very high, PowerShell can help you deliver. This chapter will show you the classes and snippets of scripts that will help you manage your SQL Server logins and database users programmatically.
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