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

Data, D365, Diabetes, Lego, …

SQL 4 CDS 6.2 Released

This is mostly a bug fix release, but with one new SQL feature implemented which could be very useful for

Read More

SQL 4 CDS 6.1 Released

It's only been a month since I released v6, but I've just published v6.1 with some useful new updates. You'll

Read More

SQL 4 CDS v6 Released

It's time for another big update to SQL 4 CDS - this one's been in the works for 3 months

Read More
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 Carrington5 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 Carrington4 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 Carrington1 Comment

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.

Category: SQL 4 CDS

Date/Time handling in SQL 4 CDS

Posted On 21st May 202121st May 2021 By Mark Carrington8 Comments

The ways different datetime columns in Dataverse/D365 behave across timezones is already the subject of plenty of blog articles. In this one I’d like to clarify how they work in SQL 4 CDS. Please pay particular attention to this if you’re updating any datetime values!

Category: SQL 4 CDS

SQL 4 CDS 5.1 Released

Posted On 6th May 20216th May 2021 By Mark Carrington32 Comments

This is mainly a bug fix release based on reports from users (thank you!) and telemetry. If you’ve hit problems running queries with SQL 4 CDS v5, please update to v5.1 and try again. If your query still doesn’t work, please let me know! You can put details of any Continue Reading

Posts navigation

Previous 1 2 3 … 11 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp