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.

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.

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

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…

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.