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

Data, D365, Diabetes, Lego, …

TDS Endpoint Time Zone Change

A change has been rolling out recently to the Dataverse TDS Endpoint that affects how date/time values are returned, which

Read More

MSDyn365 Internals: Paging Gotchas

I've recently been looking at a few cases where I've got seemingly incorrect results from my FetchXML queries. This can

Read More

Security Debugger Tool Released!

Have you ever been confronted with a permissions error message full of detailed but incomprehensible codes? Something like: Principal with

Read More
Category: SQL 4 CDS

SQL 4 CDS 3.1.0 released

Posted On 14th December 202014th December 2020 By Mark Carrington2 Comments

I’m pleased to announce that SQL 4 CDS 3.1.0 is now available to download in XrmToolBox! This release includes a lot of performance and usability related changes.

Category: FetchXML/MSDyn365/SQL 4 CDS

Dataverse Paging with Distinct

Posted On 8th December 20208th December 2020 By Mark Carrington1 Comment

I hit a strange situation yesterday. I was retrieving data from Dataverse with a FetchXML query but some values were missing from my results, while others were duplicated. Turns out it’s an easy situation to get into without noticing.

Category: MSDyn365

Improving Insert/Update/Delete Performance in D365/Dataverse

Posted On 4th December 20204th December 2020 By Mark Carringtoncomment

One of the most popular features of SQL 4 CDS has proven to be the ability to change data using INSERT, UPDATE and DELETE statements. To that end, I’ve been looking at how to improve the performance of these types of queries. Whilst I’ve been doing this with a view Continue Reading

Category: Azure/Data Platform

Combining data with Azure Data Factory

Posted On 27th November 202027th November 2020 By Mark Carrington3 Comments

You can often add more value to your data by combining it with other sources to produce an enriched data set. By keeping large reference datasets out of the main Dataverse database you can dramatically reduce storage costs. You can then combine them as needed using Azure Data Factory.

Category: Azure/Data Platform

Visualising CDM Data with Power BI

Posted On 20th November 202020th November 2020 By Mark Carringtoncomment

In my last post I loaded some data from Excel into Azure Data Lake and stored it in the Common Data Model format. Now I want to present that data using Power BI.

Category: Azure/Data Platform

Loading Data into Azure Data Lake

Posted On 13th November 202013th November 2020 By Mark Carringtoncomment

Last time I showed how to create a data lake, but how do you get data into it? What format should you store it in?

Category: Azure/Data Platform

Exploring the Data Lake

Posted On 6th November 20206th November 2020 By Mark Carringtoncomment

In the world of data technologies, you’ll probably see data lakes appearing more and more often. I’d like to take a closer look at the Azure Data Lake and how it works with the wider Azure data ecosystem.

Category: SQL 4 CDS

SQL 4 CDS 3.0.0 Released

Posted On 2nd November 20202nd November 2020 By Mark Carrington5 Comments

I’m pleased to announce that I’ve just released version 3 of SQL 4 CDS. The main updates in this release are: Metadata queries Support for virtual (___name) attributes

Category: MSDyn365

CDS Custom APIs

Posted On 22nd October 202022nd October 2020 By Mark Carrington1 Comment

Since Dynamics CRM 2013 we’ve been able to create our own APIs within the XRM framework using the Custom Action process type. Recently a new option appeared in the maker portal called Custom APIs which sounded very similar, so I thought I’d take a look.

Category: FetchXML

FetchXML Late Materialize

Posted On 9th October 20209th October 2020 By Mark Carrington2 Comments

The latest addition to FetchXML is Late Materialize. Turning this on or off doesn’t change the results of your query, but it does change how it’s executed behind the scenes, which could lead to some performance improvements.

Posts navigation

Previous 1 2 3 … 9 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp