Policy-Based Management Best Practices
Following are some best practices to consider when implementing Policy-Based Management in SQL Server 2014:
When deploying Policy-Based Management in your environment, you should be very careful about using On Change Prevent. For example, a policy that prevents stored procedure creation with the sp_
prefix prevents the enabling of replication on a SQL Server.
When you create a policy that you want enforced on all user databases, you should place this policy in the default category so that all databases are ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.