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

Data, D365, Diabetes, Lego, …

SQL 4 CDS

  • Home
  • MSDyn365
  • SQL 4 CDS
  • Page 2
Category: FetchXML/SQL 4 CDS

Integrating SQL 4 CDS with your own XrmToolBox tool

Posted On 3rd October 2021 By Mark Carrington2 Comments

One for the XrmToolBox developers: if you want to make use of the power of SQL 4 CDS from your own tool, how can you do it?

Category: SQL 4 CDS

SQL 4 CDS 5.2.2 Released

Posted On 31st August 202131st August 2021 By Mark Carrington16 Comments

I’ve just released SQL 4 CDS 5.2.2! Upgrade today for a bunch of useful updates, fixes and improvements.

Category: SQL 4 CDS

SQL 4 CDS 5.2 Released

Posted On 30th June 202130th June 2021 By Mark Carrington8 Comments

After several recent updates to Dataverse I’m excited to release SQL 4 CDS 5.2 to take full advantage of the new platform features, along with several UI and query handling improvements.

Category: SQL 4 CDS

Date/Time handling in SQL 4 CDS

Posted On 21st May 202121st May 2021 By Mark Carrington13 Comments

The ways different datetime columns in Dataverse/D365 behave across timezones is already the subject of plenty of blog articles. In this one I’d like to clarify how they work in SQL 4 CDS. Please pay particular attention to this if you’re updating any datetime values!

Category: SQL 4 CDS

SQL 4 CDS 5.1 Released

Posted On 6th May 20216th May 2021 By Mark Carrington32 Comments

This is mainly a bug fix release based on reports from users (thank you!) and telemetry. If you’ve hit problems running queries with SQL 4 CDS v5, please update to v5.1 and try again. If your query still doesn’t work, please let me know! You can put details of any Continue Reading

Category: SQL 4 CDS

SQL 4 CDS v5 Released

Posted On 29th April 202129th April 2021 By Mark Carrington13 Comments

I’m really pleased to announce this major update to SQL 4 CDS! This is a complete overhaul of the engine that converts your SQL into something that Dataverse/CRM can understand, and means you can now run a much broader set of queries than ever before.

Category: SQL 4 CDS

SQL 4 CDS 4.1.0 Released

Posted On 18th March 202118th March 2021 By Mark Carrington2 Comments

I’ve quietly been releasing minor updates to SQL 4 CDS over the past few weeks, so I thought it was time to do a blog post for an “update roll up”

Category: MSDyn365/SQL 4 CDS/T-SQL

Efficient Bulk Dataverse Updates with SQL

Posted On 2nd February 20219th March 2021 By Mark Carrington3 Comments

If you need to make bulk updates to your Dataverse or Dynamics 365 data, maybe to fix data quality problems or restructure your data, you may be exporting your data to Excel, making your changes and re-importing it. Or you may be considering setting up a more complex data pipeline Continue Reading

Category: SQL 4 CDS

SQL 4 CDS 4.0.1 Released

Posted On 28th January 202128th January 2021 By Mark Carrington12 Comments

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.

Category: SQL 4 CDS/Uncategorised

SQL 4 CDS 4.0.0 Released

Posted On 13th January 202120th January 2021 By Mark Carrington6 Comments

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

Posts navigation

Previous 1 2 3 4 Next

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp