I’m pleased to announce SQL 4 CDS 4.0.1 for working with your Dataverse data in SQL. This includes a number of improvements to SQL language support, error reporting and SSMS support.
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 – SSMS Edition, bringing many of the SQL 4 CDS features directly into SQL Server Management Studio! If you’re using the TDS endpoint this plugin expands your options directly in SSMS Continue Reading
Automating XrmToolBox Tool Build & Release
Following up on this call to action from Jonas Rapp: 📢 Calling all @XrmToolBox tool developers! Are you still building and releasing your tools manually? Stop that.Now.https://t.co/47pjRKAOT1 — Jonas Rapp ᴹᴠᴾ 🇸🇪 #ProCodeNoCodeUnite (@rappen) December 2, 2020 I decided to finally automate the build & release process for SQL 4 Continue Reading
SQL 4 CDS 3.1.0 released
I’m pleased to announce that SQL 4 CDS 3.1.0 is now available to download in XrmToolBox! This release includes a lot of performance and usability related changes.
Dataverse Paging with Distinct
I hit a strange situation yesterday. I was retrieving data from Dataverse with a FetchXML query but some values were missing from my results, while others were duplicated. Turns out it’s an easy situation to get into without noticing.
SQL 4 CDS 3.0.0 Released
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
SQL 4 CDS 2.3.0 Released!
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
Multi-select Picklist Filtering
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.
SQL 4 CDS 2.2.0 released
I’m pleased to release SQL 4 CDS 2.2.0 with two main improvements:
SQL 4 CDS 2.1.0 – the T-SQL edition
Since I’ve been doing some investigation into the new preview T-SQL endpoint for CDS recently, I’ve decided to integrate it into SQL 4 CDS. Update to 2.1.0 to get: