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

Data, D365, Diabetes, Lego, …

Month: February 2021

  • Home
  • 2021
  • February
Category: MSDyn365/T-SQL

TDS Endpoint Time Zone Change

Posted On 25th February 202123rd March 2021 By Mark Carrington2 Comments

A change has been rolling out recently to the Dataverse TDS Endpoint that affects how date/time values are returned, which should give your queries better performance but may mean you’ve got to do a bit more work to ensure the values are shown as your users expect.

Category: FetchXML/MSDyn365/MSDyn365 Internals

MSDyn365 Internals: Paging Gotchas

Posted On 23rd February 202123rd February 2021 By Mark Carrington4 Comments

I’ve recently been looking at a few cases where I’ve got seemingly incorrect results from my FetchXML queries. This can manifest itself as the results limited to 50,000 records or records being skipped. I’ve narrowed these down to some behaviour I wasn’t aware of when you retrieve multiple pages of Continue Reading

Category: MSDyn365

Security Debugger Tool Released!

Posted On 12th February 202112th February 2021 By Mark Carringtoncomment

Have you ever been confronted with a permissions error message full of detailed but incomprehensible codes? Something like: Check out my latest XrmToolBox tool, Security Debugger! Install it now so it’s ready next time you hit a security error. Simply paste in the error message and it will: highlight the Continue Reading

Category: MSDyn365/SQL 4 CDS/T-SQL

Efficient Bulk Dataverse Updates with SQL

Posted On 2nd February 20219th March 2021 By Mark Carrington10 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

Copyright © All rights reserved Theme: Infinity Blog by Themeinwp