June 2008 - Posts

• 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 Read More... Posted Thursday, June 19, 2008 12:22 AM by Lara Rubbelke | 4 Comments Filed under: Maintenance, SQL Server 2008, Policy Based Management, PowerShell

• 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 Read More... Posted Friday, June 13, 2008 1:52 PM by Lara Rubbelke | 2 Comments Filed under: SQL Server 2008, Policy Based Management

• 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 Read More... Posted Thursday, June 12, 2008 4:17 PM by Lara Rubbelke | 0 Comments Filed under: SQL Server 2008, Policy Based Management

• Where did Activity Monitor go?

  When you begin working with RC0, you may find yourself searching for Activity Monitor. I personally spent about 10 minutes looking for Activity Monitor when I started working with RC0. Luckily, I happen to work at Microsoft and can directly email people Read More... Posted Monday, June 09, 2008 4:39 PM by Lara Rubbelke | 1 Comments Filed under: SQL Server 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 Read More... Posted Sunday, June 08, 2008 11:54 PM by Lara Rubbelke | 1 Comments Filed under: SQL Server 2008, Policy Based Management