Welcome to the world of the CRM Chap!

Hello and good day to you! Why don’t you pull up a chair and have a spot of tea whilst I take you through the world of Microsoft cloud technologies? Use the slider below to navigate through some of my recent posts or you can even search through my entire post history. What fun! Still can’t find what you are looking for? Feel free to drop me a note and I would be more than happy to assist.

Getting Started with SQL Server Change Tracking

I’ve worked with SQL Server for several years now, and I am continually amazed at its capabilities, Recently, my work in this area has focused on the products change tracking feature, a nifty tool that can assist you in monitoring how your data evolves.

September 2019 Dynamics 365 Customer Engagement CSP Licensing Changes

A week is a small space of time in the Dynamics 365 Customer Engagement world at the moment, as we ramp up to the October release and the many changes this brings to the table. This week, some interesting developments occurred concerning CSP licensing for the product.

Summarising the New Dynamics 365 Customer Engagement API Request Limits & Allocations

It seems to be non-stop changes and announcements when it comes to licensing for Dynamics 365 Customer Engagement at the moment. Now, as we move into September, we get yet another, which informs us of some potentially troublesome API limits, that will take effect from October onwards.

Dealing with “An unexpected failure occurred” Error Message in Azure DevOps DACPAC Deployments

Obscure error messages can be the bane of an IT professionals life, often hampering or even preventing outright any successful resolution of issues. An example of this happened to me recently, during what appeared to be a run-of-the-mill Azure SQL automated deployment.

Evaluating Power BI Desktop Connector Options for Dynamics 365 Customer Engagement

When starting with Power Bi Desktop in conjunction with Dynamics 365 Customer Engagement, you are presented with several routes to bring your data into the application. In this week’s blog post, I take a detailed look at four of these avenues, outlining the benefits of each one.

A Few Observations on Using Custom Pricing Plugins Alongside Project Service Automation

Project Service Automation provides a cornucopia of desirable functionality for organisations wishing to integrate their sales and project management processes tightly. Be careful, though when implementing this app when using custom calculations within Dynamics 365 Customer Engagement, as you may encounter a few issues…

“A validation error occured” Data Integration Project Error (PowerApps)

Longstanding Dynamics 365 Customer Engagement professionals will be well versed in the capability to auto-create new entities and fields, based on a data import file. This functionality has been exposed fully within the Common Data Service as well, which naturally means the same kind of issues can crop up.

Dealing with “Your Azure credentials have not been set up or have expired” Error Message in a Azure Template Visual Studio Project

Keeping things simple is an idea I like to promote at all times, particularly in the world of IT. Adopting this mantra can lead to fewer headaches and, as a recent example involving Azure Template deployments within Visual Studio demonstrates, a much faster resolution to your particular problem.

Working with utcNow within an Azure Logic App Resource Template

Migrating across from Microsoft Flow to Azure Logic Apps is ridiculously easy. However, there are some critical feature differences that you must make yourself aware of. One difference relates to how triggers actions work, particularly in tandem with an Azure template.

Dealing with “SQL Bulk Copy failed due to received an invalid column length from the bcp client” Errors in Azure Data Factory

When you are amid a pesky IT issue, it can be difficult determining whether the problem is down to a bug/system fault or human error. Like this recent example involving Azure Data Factory illustrates, it is generally best to assume the latter, to avoid any prolonged difficulty.

Search the Blog


My name is Joe Griffin, and I am an IT Project Manager/Consultant, based in the North West of England. I hold various Microsoft certifications in Dynamics CRM/365 Customer Engagement, Power BI and SQL Server and am also a PRINCE2 Project Manager and Agile Practitioner. I have a broad knowledge of working with and managing projects involving Dynamics 365 Customer Engagement, Azure, Power BI, .NET and other technologies within the Microsoft cloud stack. During this time I have developed a keen interest in coding, and love working with Transact-SQL, JScript, PowerShell, DAX & C#. Thanks to my previous experience, I have practical knowledge operating within the energy efficiency, managed services, retail, print & direct mail and utility sectors.

The CRM Chap is my second attempt at maintaining a regular blog. My previous blog, which focuses on providing a retrospective view on popular culture items, can be found here.

Outside of work and blogging/tinkering, I have a keen interest in writing, reading, consuming cheesecakes, watching American/British TV Shows, playing video games and anything to do with history.