Part of a SQL Server DBA or developer's regular tasks include tracking changes, auditing databases and tables, and ensuring that instances comply with the organizational policies. SQL Server has features that allow all of these tasks to be accomplished more easily. In this chapter, we will take a look at how to enable tracking and auditing in SQL Server. We will also take a look at how to use PowerShell in order to enable and use Policy Based Management (PBM) in SQL Server to ensure compliance of settings and configurations with company rules.
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