Verbose Telemetry: a potential online SQL Profiler

When working with On-Premises (that is “still a thing” – for some/many -), you have a full control and responsibility for the backend. This implies that you have full access to the database and use, for example, SQL Server Profiler to take very detailed traces on what is happening during a specific period. What about... Continue Reading →

How to track platform changes in Dynamics 365 Business Central Online

Application hotfixes could be easily tracked using the appropriate signal diligently prepared by Microsoft some moons ago. Below an example traces | where timestamp between (_startTime .. _endTime) | where customDimensions.environmentName has_any (_environmentName) | where customDimensions.environmentType has_any (_EnvironmentType) | where customDimensions.eventId == 'LC0159' | project timestamp , environmentName = customDimensions.environmentName , environmentType = customDimensions.environmentType ,... Continue Reading →

A new cue in 23.1: love song for a vampire.

Version 23 is like a rose. It smells so good but has its thorn. We moved from 22.5 to 23.1 one of the so-called "Kennie’s elephant" (to be eaten byte after byte) in the cold night of 2nd December. In SaaS, it took 1.5 hours to upgrade this 50+ GB production database. In such dark... Continue Reading →

A simple case of modern troubleshooting with telemetry.

That day when you receive a ping like. “Hey, what happened to this request. It was quite important. Dated back 14th September. Could you explain me that? Seems like BC online was down. Keep in mind that this log could have been collected even the day after”. Errore invio dati ordine 503:{"error":{"code":"Application_ServiceUnavailable","message":"The session could not... Continue Reading →

Blog at WordPress.com.

Up ↑