The Enterprise Policy Management Framework version 3.0, a new version of the framework to support policy automated policy evaluation for SQL Server 2000 and 2005, has been posted to codeplex. For those who are not familiar with the tool, the Enterprise Policy Management Framework is a reporting solution on the state of the SQL Server enterprise ...

The next version of the Enterprise Policy Management Framework has been published to CodePlex.  The new version includes error trapping and error reporting, and a few bug fixes.  Please be sure to download the documentation as well, which will help you understand how to use the PowerShell variables to scale the execution in your ...

I have been working on some new materials for an upcoming webcast on leveraging Policy-Based Management using the Enterprise Policy Management Framework.  As I was working through some sample policies, I noticed that my SQL Server 2008 instances were not consistently configured for history retention and to log on success.  Well, I ...

In my previous blog I reviewed the different policy evaluation modes available in SQL Server 2008.  In this next installment I will detail how to initiate a policy on demand using PowerShell. PowerShell integration with SQL Server 2008 is getting more press lately.  In past blogs I noted a few resources to help learn PowerShell, and ...

SQL Server 2008 Books Online and the Policy Based Management (PBM) blog have documented how to create a policy.  Please review these valuable resources if you are looking for an introduction to creating policies in SQL Server 2008.  Through the remainder of this series, I will be focusing on the different methods of evaluating a policy ...

I will be releasing a series of blogs related to Policy Based Management and PowerShell in SQL Server 2008.  As a precursor to these blogs, I wanted to be sure that everyone is aware of the many great resources available online.   Policy-Based Management Blog The SQL Server Manageability Team has started a new blog related to ...

The SQL Server 2008 Policy Based Management framework includes views in MSDB to track evaluation history.  The syspolicy_policy_execution_history view displays information about when the policy was executed and the results of the execution.  The syspolicy_policy_execution_history_details view will display more details including the ...