SQL 4 CDS

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.

This latest update includes more powerful text-handling capabilities, particularly for non-English environments, more performance improvements and confirmation prompts in Azure Data Studio.

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!

Or, the Power Platform Conference 2022 Edition! I’m finishing this post from the conference now – if you’d like to say hello while I’m here please get in touch!

I’ve just published SQL 4 CDS 6.4 with support for earlier versions of CRM and more complex queries. I’ve also been setting up a wiki with more detailed information.

I’ve just released SQL 4 CDS v6.3 with a number of useful improvements and fixes.