CRM audit log and SQL partitioning

Last half year I spent on migrating our clients from Dynamics CRM 2011 to 2015 version. That was a long and interesting journey. In some periods it was really exhausting... Trying to manage with all the issues that come up from CRM bugs and behavior nuances to our product specific…

How to restore merge replication triggers

Issue We are using merge replication to provide some filtered data for our clients. Also we use data-tier applications for deploying latest DB schema, stored procedures, etc for our databases. Somehow it turned out that deployment of DACPAC are breaking replication. It took quite a time to troubleshoot it. The…

Configuring SQL mirroring

During configuring database mirroring via Microsoft SQL Management Studio you can stumble upon error message: The server network address "TCP://srv-sql.test.local:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are…

PrincipalObjectAccess table. Clean it up fast

In Dynamics CRM on-premise deployment PrinicipalObjectAccess (POA) table contains implicit and explicit entity sharing. Explicit sharing can be created and checked directly with UI via Share button. Implicit sharing is created during different processes by CRM itself: account merging, emails with users in CC, workflows, etc. During active CRM usage…