Data Engineering – Learn from the experts
-
Configuring Alerts to Notify Policy deviations in Policy Based Management
In this article we are going to configure alerts for policy management. Alerts are triggered when a violation takes place in a particular policy that uses any of the three automated evaluation mode. Each of these evaluation mode will return an error number starting with 340*. You can use these alerts to notify either policy…
-
How to work with Policy Based Management (PBM)
In my previous article on policy based management Ive gone through what is policy based management and how it helps administration. Lets discuss about how to work with policy based management i.e. how to create a policy and implement it. To work with a policy we need to first create a condition and we need…
-
Policy Based Management (PBM)
Introduction: Policy based management is one of the new feature added from SQL Server 2008. With the help of this feature you can evaluate an instance or database or objects to bound with in certain conditions policies. If any of the objects or instances failed to bound with in the policy then it can either…
-
Validating Replication Subscriber using TSQL
Last post from me on SQL Server replication was on How to validate subscribers in SQL Server Replication. This article shows how the same can be done using TSQL. sp_publication_validation: This system stored procedure does a validation for each and all articles in the specified publication in transactional replication. This stored procedure is executed against…
-
How to Copy Move a Database that is encrypted with TDE
In my previous articles on TDE Ive gone through whats TDE and how to configure it. Now here in this article Im going to test whether Im able to restore attach the database without encryption key since the main property of TDE is not to allow to use the physical files of the database without…
Got any recommendations?