Automate Policy-Based Management using PowerShell

  • Abstract:

    The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

    This session isn't generally well attended, yet the attendees seem to come away pleased. How could I change the abstract to attract more people?

    Thanks.

    Allen

  • 1. Your abstract does not identify to whom this is of the most interest.

    How about including: As a DBA responsible for multiple servers ......

    2.

    This session will walk you through how PBM works, how to define your policies in PowerShell,

    It does not say that your presentation will include practical examples, which I assume it does, but your not stating as such.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • I think it's partly the subject matter. People don't use PBM. I'm not sure why. It's excellent. But if you're not interested in PBM, why would you want to learn how to automate it better.

    I like the abstract. It defines the problem, offers the discussion, gives the people the takeaway. That's the general pattern I try to follow with my abstracts now, so I'm biased.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • The thing I might add in is a version of SQL this targets. That might attract some people.

    I'd also add an example of what you use PBM for. Meaning what will you show? Mention the sample policy target in the abstract.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply