Book description
Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization.
Provides in-depth treatment of policy-based management in a single source
Provides practical usage scenarios for policy-based management
Provides guidance to help meet growing regulatory compliance needs
Table of contents
- Copyright
- About the Authors
- About the Technical Reviewers
- Acknowledgments
- Introduction
- 1. Introduction to Policy-Based Management
- 2. Creating Policies
-
3. Evaluating Policies
- 3.1. Evaluation Modes
- 3.2. Evaluation on Demand
- 3.3. Evaluation on Schedule
- 3.4. Evaluation on Change: Log Only
- 3.5. Evaluation on Change: Prevent
- 3.6. Using a Central Management Server
- 3.7. Summary
- 4. Policy-Based Management Using PowerShell
- 5. Receiving Alerts for Policy Violations
-
6. Policy-Based Management Internals
- 6.1. Policy-Based Management Properties
- 6.2. Policy-Based Management Architecture
- 6.3. Policy-Based Management Security Issues
-
6.4. Policy-Based Management Tables and Views
- 6.4.1. Tables
-
6.4.2. Views
- 6.4.2.1. syspolicy_conditions
- 6.4.2.2. syspolicy_configuration
- 6.4.2.3. syspolicy_object_sets
- 6.4.2.4. syspolicy_policies
- 6.4.2.5. syspolicy_policy_categories
- 6.4.2.6. syspolicy_policy_category_subscriptions
- 6.4.2.7. syspolicy_policy_execution_history
- 6.4.2.8. syspolicy_policy_execution_history_details
- 6.4.2.9. syspolicy_system_health_state
- 6.4.2.10. syspolicy_target_set_levels
- 6.4.2.11. syspolicy_target_sets
- 6.4.2.12. Combining Views
- 6.4.2.13. Checking for New Views
- 6.5. Stored Procedures
- 6.6. Summary
- 7. Practical Uses of Policy-Based Management
- 8. Reporting
- 9. Enforcing Compliance
- 10. Where to Go from Here
- A. Microsoft SQL Server Best Practice Policies
Product information
- Title: Pro SQL Server 2008 Policy-Based Management
- Author(s):
- Release date: April 2010
- Publisher(s): Apress
- ISBN: 9781430229100
You might also like
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Microsoft SQL Server 2012 Bible
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update …
book
Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, 6th Edition
Up-to-date Microsoft SQL Server 2016 skills made easy! ?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" / …
book
Pro SQL Server 2019 Administration: A Guide for the Modern DBA
Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need …