My name is Radek and I just started my first dba job.
Currently, in my new company, there is not Policy-Based Management implemented. As one of the first tasks, I have been asked to draft and implement policies that we will be using in the future. Unfortunately, I have never worked with that tool and I am not sure what is the best way to approach that task. It is quite easy to google how to set up new policies, but I cannot find the list of good practices which actually should be considered/implemented within Policy-Based Management.
I have found/figured out a few of them:
Check if we have a current backup
Check if backups are on the same drive as data files
Check if the recovery model is set to simple at dev environments
Check if auto shrink is set to off
But I wonder (I am sure that there is, but I cannot find such thing) is there an recognized by community list of policies/good practices that should be enforced. Could you please help me to find such a list, or advise how to approach Policy-Based Management from a scratch? Could you please advise also if there are any known good practices related to that tool? (maybe it is not efficient to have more than n polices implemented, or exactly opposite we should add there everything which can be standardized)