Azure Data Explorer-Use scalar input as column name argument in extend operator in a user-defined function Dynamic Column Names in Azure Data Explorer Using Scalar Inputs with the extend Operator Azure Data Explorer ADX is a powerful tool for analyzing data at scale 2 min read 06-10-2024 51
Azure Data Explorer C# querying and ORM Unleashing the Power of Azure Data Explorer with C and ORMs Azure Data Explorer ADX is a powerful scalable and highly efficient data analytics platform Its abil 3 min read 06-10-2024 68
Print custom message when there is no data in table return by kusto query No Data No Problem Displaying Custom Messages in Kusto Queries Kusto queries are incredibly powerful for extracting insights from your data However sometimes yo 2 min read 05-10-2024 73
Flatten dependencies Flattening Dependencies Streamlining Your Projects Ecosystem Have you ever felt overwhelmed by the tangled web of dependencies in your project Its a common stru 2 min read 05-10-2024 54
I need KQL query from AzureDiagnostics to return SQL text Unlocking the Secrets of SQL Queries in Azure Diagnostics with KQL Have you ever encountered an issue in your Azure SQL database and wished you could see the ex 2 min read 05-10-2024 49
Creating a kql time series chart out of one big snapshot Turning a Snapshot into a Time Series KQL Charting Magic Imagine you have a massive dataset a single snapshot representing a moment in time You want to analyze 2 min read 04-10-2024 58
ADX Kusto how to merge two large tables Merging Two Large Tables in Azure Data Explorer Kusto When working with big data in Azure Data Explorer ADX you may often find yourself needing to combine infor 3 min read 30-09-2024 78
Why is my KQL Advance query erroring out? Understanding Why Your KQL Advanced Query Might Be Failing When working with Azure Data Explorer or Microsoft Sentinel many users encounter issues with Kusto Qu 2 min read 30-09-2024 53
"requests.exceptions.HTTPError: 400 Client Error: BadRequest for url" when querying an Azure Data Explorer table Resolving the requests exceptions HTTP Error 400 Client Error Bad Request for url Error in Azure Data Explorer Queries When querying Azure Data Explorer tables 2 min read 27-09-2024 60
Grafana - Combining Azure Data Explorer Datasource with a static source Grafana Combining Azure Data Explorer Datasource with a Static Source In the world of data visualization and monitoring Grafana stands out as a powerful tool th 3 min read 25-09-2024 72
How to use !has on an array in KQL How to Use has on an Array in KQL In Kusto Query Language KQL filtering data with conditions related to arrays can be quite powerful One such condition is the h 2 min read 25-09-2024 63
I need to run multiple queries at one time Running Multiple Queries Simultaneously A Comprehensive Guide When working with databases its common to encounter situations where you need to execute multiple 2 min read 24-09-2024 58
Application Insights KQL query - not in sub query Understanding Application Insights KQL Queries Avoiding Subqueries In the world of Application Insights one of the most powerful tools for analyzing and queryin 2 min read 23-09-2024 75
LogAnalytics KQL query to identify column size within a table Understanding Log Analytics KQL Query to Identify Column Size Within a Table When working with Azure Log Analytics and its powerful query language Kusto Query L 2 min read 23-09-2024 70
Application Insights - Render timechart with two queries Application Insights Rendering Timecharts with Two Queries In the world of application monitoring Application Insights stands out as a powerful tool to track pe 2 min read 22-09-2024 70
Kusto query for time between records by group in one result list Kusto Query Finding Time Between Records by Group When working with Kusto Query Language KQL one common task is to analyze time intervals between records within 2 min read 20-09-2024 70
How to find non distinct/duplicate messages in Azure Application Insights? How to Find Non Distinct Duplicate Messages in Azure Application Insights Azure Application Insights is a powerful tool for monitoring and diagnosing applicatio 2 min read 19-09-2024 61
How to summarize a summarization How to Summarize a Summarization A Comprehensive Guide In todays fast paced world the ability to efficiently distill information is crucial Summarizing a summar 2 min read 16-09-2024 82
KQL Query to filter duplicate entries and select top 1 from the log data How to Filter Duplicate Entries in Log Data Using KQL Queries When working with large datasets especially log data duplicate entries can pose significant challe 2 min read 16-09-2024 55
Generate Chart by Type and State Generating Charts by Type and State A Comprehensive Guide When working with data visualization one common requirement is to generate charts based on different t 2 min read 14-09-2024 81
Azure Resource Graph - Database sizes Understanding Azure Resource Graph Database Sizes Azure Resource Graph is a powerful tool that enables users to explore and query Azure resources at scale It pr 2 min read 14-09-2024 60
Create a function to calculate power of tens with a loop and reuse them in another query Creating a Function to Calculate Powers of Ten In programming one of the common tasks is to compute powers of numbers efficiently For instance calculating power 2 min read 14-09-2024 80
Creating KQL query to get Azure VMs not patched since 30days Finding Unpatched Azure VMs A KQL Guide Identifying Azure VMs that havent been patched in the past 30 days is crucial for maintaining security and stability Thi 2 min read 13-09-2024 56
Kusto: Query execution has exceeded the allowed limits (80DA0003): Kusto Tackling Query Execution Has Exceeded the Allowed Limits 80 DA 0003 This article dives into a common issue encountered in Kusto queries the dreaded Query 3 min read 05-09-2024 63
where' operator: Failed to resolve table or column expression named 'ConfigurationChange' where operator Failed to resolve table or column expression named Configuration Change Troubleshooting Azure Log Analytics Queries Encountering the where operat 2 min read 04-09-2024 58