Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By : Donabel Santos
Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By: Donabel Santos

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
Index

Introduction


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.