Articles tagged KQL

21 February 2024
21 February 2024

Eventstream and the new KQL Processing

0
1
Eventstream has many differences in relation to the technologies it proposes to replace. Event Hub, Stream Analytics, Streaming Dataflows and more. We can compare these technologies, but EventStream in Microsoft Fabric has some specific differences from all of them. One of the differences is how the transformation of the input data is linked to the … Read more
31 January 2022
31 January 2022

Saving and Sharing Log Analytics Query

0
2
Update on 01/03/2022: There are two small mistakes on the article below. A) On the UI, the only Tag value which accepts customization is Label. I believe the customization is possible through API, but I haven’t checked it. B) The filter and group by using the Label tag is possible. The Label only appears as … Read more
16 August 2021
16 August 2021

Creating functions in Kusto Queries

0
2
In the previous blog, I illustrated how to create sub-queries in Kusto. However, sometimes we may face even more complex situations and we may need to create not only a sub-query, but a function. Another way to think about a function inside a Kusto query is like a parameterized sub-query. Let’s review the query from … Read more
09 August 2021
09 August 2021

Creating Kusto sub-queries

0
14
In the same way as other query environments, Kusto queries in Log Anaytics can become complex. We need similar features in Kusto as we have in SQL Queries and one of these features is sub-queries. The Problem On the example below I’m building a query over my blog’s Log Analytics Data to identify the amount … Read more
01 May 2021
01 May 2021

Saving money with Log Analytics

0
1
Azure Monitor and Log Analytics are a very important part of Azure infrastructure. In my opinion, the adoption of these tools should start before a company starts its migration to azure. Using these tools over on premises servers can generate a performance baseline to be used when migrating the servers, ensuring the environment will be … Read more