THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » Policy Based Management   (RSS)
  • Automating SQL Server 2005/2000 Policy Evaluation

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 13, 2009
  • Enterprise Policy Management: Updates, New Whitepaper, and Upcoming Webcast

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on March 4, 2009
  • Policy-Based Management Configuration Policy

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on February 28, 2009
  • Evaluating Policies On Demand Through PowerShell

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 19, 2008
  • Policy Evaluation on a Single SQL Server 2008 Instance

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 13, 2008
  • SQL Server 2008 Policy Based Management Resources

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 12, 2008
  • Saving SQL Server 2008 Policy Based Management Execution History

    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 ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on June 8, 2008
Privacy Statement