Post reply

Policy management

  • August 30, 2012 at 5:28 pm

    #266053

    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?

    thanks

  • August 30, 2012 at 7:10 pm

    #1532172

    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.

  • August 31, 2012 at 11:08 am

    #1532541

    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.
    --Plato

  • August 31, 2012 at 6:06 pm

    #1532661

    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

  • August 31, 2012 at 7:26 pm

    #1532664

    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
    MCITP | MCTS

    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