Policy management

  • I have not made use of Policy management yet in SQL server.

    I would like to know from other DBAs what are the policies you are using?


  • Since Surface Area Configuration was done away with in SQL 2008, I have created a policy for some servers that utilize secure the surface area.

  • I have implemented most of the policies offered up by Microsoft as Best Practices...

    Monitoring Best Practices by Using Policy-Based Management

    ...plus I roll a few of my own tailored to the specific environment.

    There are no special teachers of virtue, because virtue is taught by the whole community.

  • I have used policies to ensure developers create objects in the correct schema. E.g. We want stored procs in environment X to go into schema xxx.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • i've use policy to ensure the correct schema, default names to tables, views, proc, functions.....

    applying rules of company!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

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

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