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

Data, D365, Diabetes, Lego, …

SQL 4 CDS v9.6 released

Lots of new possibilities for working with your Dataverse data with this latest update! (more…)

Read More

SQL 4 CDS v9.5 Released

Updates to SSMS compatibility, bulk operations, optionset metadata access & more... (more…)

Read More

SQL 4 CDS v9.4 Released

I was reviewing some incredible usage stats for SQL 4 CDS recently which showed that UPDATE statements make up almost

Read More
Category: MSDyn365/T-SQL

CDS T-SQL Endpoint pt 7 – Extensibility

Posted On 19th May 202028th September 2020 By Mark Carringtoncomment

One of the aspects of the CDS platform I’ve liked since Dynamics CRM 4.0 is the extensibility options – the ability to add plugins into the core of the engine so that your custom code will be executed however someone is using it, whether through the standard UI, portals, external Continue Reading

Category: MSDyn365/T-SQL

CDS T-SQL Endpoint pt 6 – Aggregates

Posted On 18th May 202028th September 2020 By Mark Carrington3 Comments

One of the things that is very frustrating when trying to do any sort of analysis of data in CDS is the fetch aggregate limit. If you haven’t come across this before, this is a hard limit of 50,000 records that it will process when trying to calculate aggregate values Continue Reading

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 5 – EntityFramework / ORM

Posted On 16th May 202021st September 2024 By Mark Carrington1 Comment

Now I can reliably connect to the CDS T-SQL endpoint and execute queries against it, I want to get the data into some objects for me to use. I currently use EntityFramework and Dapper for this in other projects, so I’ll take a look at those two.

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 4 – Performance

Posted On 15th May 202028th September 2020 By Mark Carrington1 Comment

A common question I’ve seen so far about the new CDS T-SQL endpoint is how it compares performance-wise to using FetchXML. After all, FetchXML is “native” to CDS while T-SQL might be viewed as the johnny-come-lately compatibility layer, so it’s going to be slower, right?

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 3 – SqlClient

Posted On 14th May 202028th September 2020 By Mark Carrington18 Comments

As a developer, the first thing I want to do with any new tool is try and integrate or extend it with my own code. This is always one of the real benefits of CDS and the Power Platform for me, as it’s so much more open to extensibility than Continue Reading

Category: MSDyn365/T-SQL

CDS T-SQL endpoint pt 2 – First Thoughts

Posted On 13th May 202028th September 2020 By Mark Carrington2 Comments

Let me just say, this thing is going to be great. It’s the biggest advancement in the platform for some years, and I don’t think any competitor will come close. However, it is a preview feature, and it does have some issues. Hopefully some of these at least will get Continue Reading

Category: MSDyn365/T-SQL

CDS T-SQL Endpoint pt 1 – Connecting

Posted On 13th May 202022nd October 2020 By Mark Carrington21 Comments

The biggest announcement of MBAS for me by a long way was the new T-SQL endpoint. For those who missed it, go and check out the recordings.

Category: MSDyn365

D365UG UK: Data Integrity & Quality – Tips & Tools

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

A bit of a mouthful of a title! I had a great time earlier today presenting at my first ever virtual event, D365UG UK. Many thanks to the organising team for a smoothly run event!

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 2.0.0 released!

Posted On 17th April 202028th September 2020 By Mark Carrington4 Comments

I’m very pleased to release version 2.0.0 of my SQL 4 CDS tool today! If you haven’t come across it before, SQL 4 CDS is an XrmToolBox tool to query and manipulate your CDS data using regular SQL queries, making it accessible to a much wider range of users. You Continue Reading

Category: FetchXML/MSDyn365

Inside FetchXML pt 10 – link-entity (again)

Posted On 5th April 202028th September 2020 By Mark Carrington1 Comment

A follow-up on my previous post on link-entity, prompted by this tweet from Daryl LaBar: Was unaware of the new join operators. @jordimontana @XrmWizard have either of you used these, or know what they are supposed to do? The documentation is rather lacking…https://t.co/Nr4AyZMzb2 — Daryl LaBar (@ddlabar) April 2, 2020

Posts navigation

Previous 1 … 10 11 12 … 14 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp