Skip to content
Primary Menu
  • Home
  • About
  • Blog
  • SQL 4 CDS
  • Twitter
  • LinkedIn
  • GitHub
Mark Carrington

Data, D365, Diabetes, Lego, …

Using Dates from TDS Endpoint in Power BI Charts

As part of migrating some dashboards to Power BI using the TDS Endpoint I hit a problem getting a chart

Read More

SQL 4 CDS 4.0.0 Released

I'm pleased to announce the release of version 4.0.0 of SQL 4 CDS. This release introduces SQL 4 CDS -

Read More

TDS Endpoint Queries with Time Zone and User details

A common issue I used to encounter with SQL-based reports for on-premise Dynamics CRM instances was correctly & efficiently filtering

Read More
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 Carringtoncomment

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.

Category: FetchXML/MSDyn365

Querying Metadata with FetchXML

Posted On 29th September 202029th September 2020 By Mark Carringtoncomment

I’ve looked at different ways of accessing CDS metadata recently, but there’s another way I’d overlooked – using FetchXML. CDS exposes a limited amount of metadata as special virtual entities that lets you query it using standard FetchXML syntax:

Category: MSDyn365/T-SQL

CDS T-SQL Endpoint Vulnerability

Posted On 24th September 202022nd October 2020 By Mark Carrington5 Comments

I received a notification today that the preview TDS endpoint had been disabled on my environment because of a security vulnerability.

Category: Azure/Diabetes

Picking the right data technology

Posted On 22nd September 202028th September 2020 By Mark Carringtoncomment

I’ve been studying lately for the Azure Data Engineer Associate certification, and the main point of one of the exams (DP-201 – Designing an Azure Data Solution) is all about picking the data platform(s) that best meet the requirements. Having used SQL Server for many years it’s a simple trap Continue Reading

Category: MSDyn365

Retrieving Metadata in D365 / CDS

Posted On 10th September 202028th September 2020 By Mark Carringtoncomment

One of the things that really attracts me to the D365 platform is its metadata capabilities. As an ISV we make a lot of use of this at Data8, making sure our solutions automatically adapt to the customizations that each customer has made in their own system. There are a Continue Reading

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 2.3.0 Released!

Posted On 1st September 202028th September 2020 By Mark Carringtoncomment

I’m pleased to release the latest update for SQL 4 CDS today! For this update I’ve focused on common problems I’ve seen people encounter with their queries from my telemetry. These updates should either mean that more queries can be executed immediately, or the error message is more descriptive to Continue Reading

Category: FetchXML/MSDyn365/SQL 4 CDS/T-SQL

Multi-select Picklist Filtering

Posted On 27th August 202028th September 2020 By Mark Carringtoncomment

I’ve been doing some work today on filtering multi-select optionset fields in SQL 4 CDS and using the T-SQL endpoint, and I came across a few interesting quirks.

Posts navigation

Previous 1 2 3 … 8 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp