SQL 4 CDS

I was reviewing some incredible usage stats for SQL 4 CDS recently which showed that UPDATE statements make up almost 75% of the queries you run! So I thought it was time to add in some improvements in this area that I’ve been meaning to do for a while…

The latest update is here with lots of improvements to get into!

Copilot for Sales, Copilot for Service, Copilot for… SQL 4 CDS?

It’s been an exciting time for Dataverse recently – following on from the various newly-documented features in FetchXML we now also have a recycle bin feature! So definitely time for a new SQL 4 CDS update…

The latest version of SQL 4 CDS is finally here! There’s too many new features and updates to list them all, but I’ll call out a few of my favourites here.

The big new feature in this update is Common Table Expression support and enhanced JSON functionality.

It hasn’t been long since the previous release, but there’s some important fixes in this version along with some useful new features and performance improvements.

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

This latest update lets you access data in the preview long-term retention feature along with lots of performance improvements and bug fixes.

This update includes support for the new Elastic Tables feature, XML data type and more.