How to Create Temp Tables in SQL Server
When working with data in Microsoft SQL Server, you sometimes need a place to store intermediate results. Maybe you need this for a complex calculation,...
Admin Monitoring Workspace in Microsoft Fabric
When you start using Microsoft Fabric, one of the first things you want to know is what is happening behind the scenes. Datasets are refreshing,...
Levenshtein Distance Calculation in Microsoft Fabric
When you work long enough with business data, you eventually run into one of the biggest headaches in data management – duplicates. Levenshtein distance calculation...
How to Use TRY CATCH in SQL Server
When working with Microsoft SQL Server, things don’t always go as planned. Maybe a query fails because of a constraint, a divide-by-zero error, or a...
App Insights Telemetry for D365F&O
In the past few months, many people have asked me how they can prepare for Microsoft’s upcoming license enforcement in Dynamics 365 Finance and Operations...