Lots of updates with subqueries, getting server information and more in this latest update. More Efficient Subquery Filters You’ve been able to use subqueries for a long time with SQL 4 CDS, but this update brings some significant performance improvements to some of the ways they can be used. This Continue Reading
SQL 4 CDS v7.4 Released
This latest update lets you access data in the preview long-term retention feature along with lots of performance improvements and bug fixes.
SQL 4 CDS v7.3 Released
This update includes support for the new Elastic Tables feature, XML data type and more.
Elastic Tables in Dataverse
Did you notice a new option appear when you create a new table in Dataverse recently? What does it mean, and what happens if you select it?
SQL 4 CDS v7.2 Released
This latest update includes more powerful text-handling capabilities, particularly for non-English environments, more performance improvements and confirmation prompts in Azure Data Studio.
SQL 4 CDS v7.1 Released
Along with some important updates to the existing SQL 4 CDS suite of tools, this release brings brand new integrations for SSMS 19 and Azure Data Studio!
MSDyn365 Internals: Restricted state transitions
In my last post I looked at how some of the core Sales entities are read-only in everything except their default state, and how you may need to go through a series of transitions between different states to edit them. Although these are the only entities I’m aware of that Continue Reading
MSDyn365 Internals: Read-only Sales entities
If you work with the standard D365 Sales entities like Quote, Order and Invoice you might have had users come across error messages like Most entity types have Active and Inactive states but can actually be edited via the API even when they’re inactive. These three sales entities have some Continue Reading
MSDyn365 Internals: Plugin Debugging from SDK and Web API apps
I’ve written a fair few apps to integrate with Microsoft Dynamics 365 over the years, and you can guarantee at some point you’re going to hit an error that’s triggered by a plugin when you update a record. How do you find the true cause of the error and start Continue Reading
Early-bound and Async support for on-prem D365
I’ve just released version 2.3 of the Data8 Dataverse client library, which you can use to connect to on-premise instances of Dynamics CRM / Dynamics 365 from .NET Core apps.