Skip to content
Primary Menu
  • Home
  • About
  • Blog
  • Tools
  • Twitter
  • LinkedIn
  • GitHub
Mark Carrington

Data, D365, Diabetes, Lego, …

Year: 2021

  • Home
  • 2021
Category: SQL 4 CDS

SQL 4 CDS 5.3 Released

Posted On 27th November 202128th November 2021 By Mark Carrington20 Comments

I asked a little while ago what new features you’d most like, so here’s the first of them: cross-instance queries!

Category: MSDyn365

Connecting to on-prem Dynamics from .NET Core without OAuth

Posted On 15th November 202115th November 2021 By Mark Carrington6 Comments

If you’re like me you’ll have been excited recently with all the improvements coming in .NET, first with .NET Core and now with .NET 5 and 6. But as Dynamics developers we’ve been locked into using .NET Framework by the Dynamics SDK. Thankfully that’s changing with the preview Dataverse ServiceClient, Continue Reading

Category: MSDyn365

Merge Permissions Tool

Posted On 13th October 202113th October 2021 By Mark Carrington5 Comments

One of my most popular blog posts, and one I keep finding myself referring back to, is on the D365 merging process. It’s often difficult to get security roles just right so they allow merging records without giving way too many permissions. Finally, I’ve finished a tool I’ve wanted for Continue Reading

Category: FetchXML/MSDyn365

Identifying merged records

Posted On 6th October 20216th October 2021 By Mark Carrington1 Comment

You can use duplicate detection rules to find duplicate records in Dynamics 365 (or do it even better with Data8 Duplicare!), but how do you go back and find what records have been merged, or by whom?

Category: FetchXML/SQL 4 CDS

Integrating SQL 4 CDS with your own XrmToolBox tool

Posted On 3rd October 2021 By Mark Carrington2 Comments

One for the XrmToolBox developers: if you want to make use of the power of SQL 4 CDS from your own tool, how can you do it?

Category: SQL 4 CDS

SQL 4 CDS 5.2.2 Released

Posted On 31st August 202131st August 2021 By Mark Carrington16 Comments

I’ve just released SQL 4 CDS 5.2.2! Upgrade today for a bunch of useful updates, fixes and improvements.

Category: MSDyn365

Faster Web API Metadata Access

Posted On 23rd July 202123rd July 2021 By Mark Carrington10 Comments

I was recently updating a Javascript web resource that needs to use the Dataverse Web API to get some table metadata. This was taking around 5 seconds to get all the information it needed, but with a few changes I got that down to about 0.2 seconds.

Category: SQL 4 CDS

SQL 4 CDS 5.2 Released

Posted On 30th June 202130th June 2021 By Mark Carrington8 Comments

After several recent updates to Dataverse I’m excited to release SQL 4 CDS 5.2 to take full advantage of the new platform features, along with several UI and query handling improvements.

Category: MSDyn365

Bypassing plugins in Dataverse: faster, simpler data imports

Posted On 27th May 202127th May 2021 By Mark Carrington10 Comments

Data migration can be one of the most time consuming parts of deploying a new CRM system, and all that complex business logic in your shiny new plugins just complicates matters. At best they just slow down the import, or worse they change your historical data according to your latest Continue Reading

Category: MSDyn365

Improving bulk Dataverse performance with EnableAffinityCookie

Posted On 26th May 202126th May 2021 By Mark Carrington2 Comments

A few months ago I investigated how using multi threading and batching requests can be used to improve the performance of Dataverse integrations. In the latest release of the Dataverse tooling we’ve now got another option to use – EnableAffinityCookie. Let’s have a look at how that can help too.

Posts navigation

1 2 3 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp