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

Data, D365, Diabetes, Lego, …

Month: January 2021

  • Home
  • 2021
  • January
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: MSDyn365/PCF

PCF Usage Inspector 1.2.1 Released

Posted On 25th January 202125th January 2021 By Mark Carringtoncomment

I’m pleased to announce the release of PCF Usage Inspector v1.2.1 for XrmToolBox today. This release adds some key new functionality to let you make sure you’re using PCF controls consistently across your environments. If you’ve just developed or imported a great new PCF control, PCF Usage Inspector can help Continue Reading

Category: Data Platform/MSDyn365/T-SQL

Using Dates from TDS Endpoint in Power BI Charts

Posted On 19th January 202119th January 2021 By Mark Carringtoncomment

As part of migrating some dashboards to Power BI using the TDS Endpoint I hit a problem getting a chart to show correctly. I needed to show invoices with the values grouped by month. This is simple in a standard Dynamics chart, and when importing the data into Power BI. Continue Reading

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

Category: MSDyn365/T-SQL

TDS Endpoint Queries with Time Zone and User details

Posted On 2nd January 202125th February 2021 By Mark Carrington1 Comment

A common issue I used to encounter with SQL-based reports for on-premise Dynamics CRM instances was correctly & efficiently filtering on dates. In the underlying SQL tables, Dataverse stores dates & times in UTC time zone, and this is how they’re indexed. In the views that the TDS Endpoint exposes Continue Reading

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp