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.

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...

Validating Azure Resource Templates within an Azure Build Pipeline

Validating your Azure templates manually can be a challenging task to complete at scale. Fortunately, with the functionality available within Azure Pipelines, this entire process can be fully automated. This post will show you just how easy it is to implement automatic validation an deployment of your Azure templates within a CI process.

How to Define Streaming Units for Microsoft.StreamAnalytics/streamingjobs Resource

When working with Azure templates for the first time, there's always a risk of misconfiguring a setting. All fine when testing, until you realise you have been charged an unexpected amount on your credit card. In this post, I provide an example of this in practice when working with Stream Analytic Job resources.

Working with Variables in an Azure DevOps Release Pipeline

Working with variables within your Azure DevOps Pipeline can give you a high degree of latitude when planning your software deployments. When utilised as release variables, additional functionality is exposed, allowing you to alter the conditional flow within your pipeline dramatically. In this week's post, we'll find out how to use them in practice.

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.