Tip #302: Optimize CRM by updating statistics and reorganizing indexes

Another SQL nugget from Gayan “Mr Performance” Perera: If you’re running CRM (any variant) on-premise you can optimize the speed of the system by setting up two management jobs inside SQL. First, update statistics of the organization_MSCRM database every day (outside business hours). Second is to reorganize the indexes of the organization_MSCRM database every 2-4 […]

Tip #299: Schedule CRM on premise reports

Jim “Sourdough Master” Steger sent us a fresh reminder that, despite all the advantages of CRM Online deployments, on premise installations have a few aces up their sleeves when it comes to reporting, and here is one of them: Don’t forget about the ability to schedule SQL Server Reporting Services (SSRS) reports when using CRM […]

Tip #279: Don’t reuse AD accounts

Rename user in CRM

Jon Lagavulin has left and Jim Laphroaig has joined the company. Same role, same position, even the same salary. In fact, Jim is supposed to take over all the leads, customers and opportunities left behind by Jim. It’s very tempting to rename Jon’s account in Active Directory – select the user object, press F2, type […]

Tip #68: Do you know this woman?

Annoying prompt to watch the video

I have nothing personal against this woman but the dialog started to annoy me to no extent. The problem is that visibility of the dialog is controlled via cookie so even if you check the box “Don’t show me this again”, you will see it again if you clear your cookies, use another device, or use […]