Tip #609: Higher SQL compatibility level does not mean better

Gayan “Performance Wizard” Perera continues to live up to his nickname with another awesome performance tip. tl;dr Beware setting the SQL database compatibility level to a level higher than 110 on a CRM 2016 system. The scenario You have an entity with more than 5 secured fields. When the record is opened it either times […]

Tip #596: Prepare client customizations or watch the paint dry

Prepare Client Customizations

This truck stop is somewhat unusual. Traditionally, we have a question and one or more answers to serve. This time we have two people independently arriving at the same question. tl;dr If you are rolling out Dynamics CRM mobile apps or customizing Interactive Service Hub, don’t forget to click Prepare Client Customizations after you publish […]

Tip #558: O Mailbox Statistics, Where Art Thou?

Mailbox statistics are not useful on large deployments

Challenge Joel can be such a pain, he always keeps asking some questions no one seems to know the answer for. Like the other day: What are these sync cycle processing records that feed the server side sync performance dashboard? I don’t see them in the system job log. Is there any way to bulk […]

Tip #347: How to use datetime fields in WHERE clause

Gotta love user Q&A sessions, like the one at Convergence 2015 that I had a privilege to take part in. Questions from users are always refreshing, very often challenging and sometimes they are just the reminder that any small bit of information that one possesses is not necessarily the common knowledge. On this occasion question […]

Tip #87: Somebody needs to own it

At Convergence 2014, the tipsters participated in some “Ask the MVP” sessions. There were many great questions, and I wanted to highlight a few of them. One great question was how should you deal with issues that can be a problem for any enterprise system, such as performance, poor user adoption, duplicate data, and other […]

Tip #39: Custom indexes in CRM Online

A little known secret for CRM Online users and a good reminder from Daniel Cai. If you’ve added additional search fields to your Quick find or other views, the underlying entity contains a large number of records, and the response time is slow, you might need a custom SQL index added to improve the performance. […]