SQL Server security and Policy Based Management – Alerting In recent posts related to the SQL Server Policy Based Management feature, we discussed and provided steps and tips to create conditions and policies that help maintaining SQL Server security in large enterprises with a number of #SQLServer instances. Now, we are going to go further as once set policies are not much of a use if their violations are left unnoticed The general idea is to receive a notification in such cases and be informed of policy violation details. For instance, if policy rules are violated, the policy cannot do much, except when used in the On change: prevent #evaluation mode. However, as that mode is limited to few conditions, we will focus on a general policy violation alerting scenario To be continued...
Posted on: Thu, 20 Mar 2014 19:39:46 +0000
Trending Topics
Recently Viewed Topics
© 2015