Wednesday, April 23, 2014     | Register
Policy Based Management

 

Policy Based Management WebCast

 

Formerly known as DMF or DMgF, Policy Based Management brings significant changes to the way in which DBA's apply SQL Server policy across the enterprise. In this webcast, Hongfei Guo from the SQL Server Manageability Team demonstrated this new feature ... Source : Hongfei Guo - SQL Server Manageability Team - WebCast

 

 

Policy Based Management - Evaluation with Powershell

 

A great series of blog posts from Lara on Policy Based Management. In this one, she demonstrates how we can use powershell scripting to evaluate policies. Whilst not required for SQL Server 2008 instances (as we can store/automate policies in the server) it's a great technique for automating policy checks against older SQL Server instances (2000 and 2005) ... Source : Lara Rubbelke - SQLBlog.com - Blog Post

 

 

Policy Based Management - Facet-Evaluation Mode-Target Mapping

 

I've been looking for a blog post like this for a while. As well as explaining the concepts behind Policy Based Management, Dan provides a matrix which maps Facets by Target Type (and Target Types by Facet) as well as listing the supported evaluation modes for each facet. In a related post, Peter DeBetta provides a script to list the mappings. This will be very useful in later releases of SQL Server 2008 to discover any changes from the currently supported mappings in RC0 ... Source : MSDN Blogs - Dan Jones - Blog Post

 

 

Defining Complex Health Policies with Policy Based Management

 

As Bart demonstrates, the ExecuteSQL function can be used to define much more complex health conditions with Policy Based Management, for example; The average disk response time for all data and log files that have a non-trivial number of I/Os should not exceed 100ms ... Source : Bart Duncan - MSDN.com - Blog Post

 

 

Enterprise Policy Management Framework

 

As per the description on codeplex … "The Enterprise Policy Management Framework is a reporting solution on the state of the enterprise against a desired state defined in a policy. Extend Policy-Based Management to all SQL Server instances in the enterprise. Centralize and report on the policy evaluation results" ... Source : Codeplex.com

 

 

Central Management Servers

 

In addition to enabling policy evaluation across groups of servers, Central Management Servers come with a host of other benefits, as Kimberly points out in this blog post ... Source : Kimberly L Tripp - SQLSkills.com

 

 

Enterprise Policy Management Framework

 

The Enterprise Policy Management (EPM) Framework extends Policy Based Management from a single server instance to the entire enterprise, including the ability to cover SQL Server 2000 and 2005 instances. Other advantages include the ability to centralize the policy evaluation results to a single repository. This whitepaper covers best practices for using the EPM Framework ... Source : SQLCAT.com - Whitepaper

 

 

Policy-Based Management Configuration Policy

 

For all the things Policy Based Management can do, one of the things it can't do is check its own configuration. In addressing this issue, Lara provides us with a script to create a custom policy for this purpose ... Source : Lara Rubbelke - SQLBlog.com

 

 

SQL Server 2008 Compliance Guide

 

This whitepaper provides an overview of the SQL Server 2008 features that can be utilized for compliance purposes. As well as covering Policy Based Management, it covers security techniques such as separation of duties, encryption and auditing ... Source : Microsoft.com - Whitepaper 



Copyright (c) 2014 sqlCrunch.com   |  Privacy Statement  |  Terms Of Use