Analysis – Pardaan.com

Guidelines for Partners: Code Analysis Tools

A code analyzer is a library that builds on the compiler’s functionality to offer enhanced analysis of the syntax and semantics of your code at build time. AL code analyzers are used in order for the code to be more readable and orderly, most of the…

28 January 2022

Data & Analysis

View Native Query Now Works For Analysis Services Data Sources

If you’re familiar with the topic of query folding in Power Query, you’ll know that the View Native Query right-click option in the Applied Steps pane of the Power Query Editor can be used to show the native query that is run against the data source.…

13 October 2020

Dynamics NAV & BC Tips & tricks

Dependency Analysis Tool (ALDependencyAnalysis)

Remember this post? Probably not. Nearly a year ago at Directions US, I showed some “how did I do stuff” during a number of sessions. And it ended with a lot of feedback, which came down to: “can I have it”? So, that’s where I wrote…

27 April 2020

Data & Analysis

Visualising Power BI Premium And Azure Analysis Services Query Parallelism

In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful. In this post I’ll show you how you can use a Profiler trace to…

17 March 2020

Data & Analysis

SQLBits Power BI And Analysis Services Videos Now Free To View Online

SQLBits is one of the best Microsoft data platform conferences around, and last week’s event in Manchester was particularly good. As usual, videos of almost all of the sessions are available for everyone to view for free online (no registration required) here: Source : Chris Webb's…

12 March 2019

Dynamics NAV & BC Tips & tricks

C/AL Source Code Analysis with PowerShell

Last Directions US and EMEA, I had the opportunity to talk about – uhm – myself. Well, not really – about my tools. It was a weird experience – but it got more attention than I ever expected. Now, during that session, I showed a tool…

21 February 2019

Dynamics NAV & BC Tips & tricks

AL Code Analysis Rules (Diagnostic Descriptors) – Updated Again

I have been blogging a few times about the Diagnostic Descriptors we get when enabling code analysis. Well – yet again, we have new ones. But I’m not going to keep updating these rulesets, as Microsoft is now doing that on docs. So let me give…

25 September 2018