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.

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.

Resolving “No IP address is available to hand out to the dial-in client.” VPN Errors (Windows Server Routing and Remote Access)

Sometimes in IT, you can hit a brick wall when working with something outside of your comfort zone. When this occurs within a personal testing environment, then it also means that resolving errors, such as IP address assignment for the Windows Server Routing and Remote Access service, can be somewhat challenging…

Utilising the Application Insights API Key with Power BI

The ability to consume Application Insights data from directly within Power BI is an excellent feature in what is already a pretty outstanding product. However, there will likely be some steps that you have to follow to ensure that your reporting solution is secured, using an appropriately privileged API key.

Resolving AADSTS50126: Invalid username or password Errors During Azure SQL Database Deployment Task (Azure DevOps Pipelines)

We saw a few weeks ago how to utilise Azure Active Directory (AAD) Security Groups to manage Azure SQL database access at scale. When using this feature, you must ensure database changes are deployed out using an AAD administrator account or similar, a task which may be difficult to achieve in an Azure DevOps Pipeline.

Extract New Record GUID from Dynamics 365 Customer Engagement Create Web API Request (C#)

Having the ability to straightforwardly obtain a records Globally Unique Identifier after programmatically creating it within Dynamics 365 Customer Engagement can help significantly with data integration requirements. This is a relatively easy task when working with the Web API using JScript but less so if C# is your language of choice...

Managing Azure SQL SSO with Azure Active Directory Security Groups

Azure SQL Server has long supported the ability to use Azure Active Directory user accounts to access and work with databases. What you may not know is that it is also possible to add users via membership of a security group, a feature which, I believe, is incredibly useful for managing large-scale deployments.

Sink Limitations with the Dynamics 365 Customer Engagement/Common Data Service Connector for Azure Data Factory

The Dynamics 365 Customer Engagement/Common Data Service connector for Azure Data Factory can, in most cases, fit into your data integration needs. However, it is worth highlighting the two field types which are, specifically, not supported; namely, the Customer and Owner field types.

Working with Custom Dynamics 365 Customer Engagement Dataset Schemas in Azure Data Factory V2

By default, the Dynamics 365 Customer Engagement connector for Azure Data Factory V2 exposes a predefined list of fields, that must have data mapped to them for any Copy Data task to complete successfully. This behaviour can be impractical depending on your particular scenario; fortunately, there is a way in which you can override this.

Xrm.Page Object Deprecation: Check your Dynamics 365 Customer Engagement JScript

Feature deprecations can often cause some degree of disruption, especially if they involve custom code. Microsoft has recently deprecated the Xrm.Page object for JScript form functions in Dynamics 365 Customer Engagement. Find out more about this change and what you will need to do to fix this as part of this week's blog post.

Dynamics 365 Customer Engagement Connector Confusion with Azure Data Factory

Azure Data Factory V2 not just has 1, but three separate connectors that all claim to hook up to Dynamics 365 Customer Engagement/Dynamics CRM! So which connector is the "right" one to use and what differences do they have? With a little help from Alan Partridge, we can clear up any confusion...

Search the Blog

ABOUT THE CRM CHAP

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.