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!
SQL 4 CDS 5.1 Released
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
SQL 4 CDS v5 Released
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.
SQL 4 CDS 4.1.0 Released
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”
Efficient Bulk Dataverse Updates with SQL
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
SQL 4 CDS 4.0.1 Released
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.