cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Data Explorer Blog
Options
909

Building an Azure Service Tag Lookup utility with KQL and a Free Cluster

Gilles_LHerault on Nov 24 2022 09:24 PM
Service Tag KQL Lookup If you are a network professional, dealing with IP addresses is a fact of life when architecting ...
1,085

Migrate seamlessly your ADX cluster to Lsv3-series for reduced costs and better performance

Iris_Kaminer on Nov 24 2022 02:31 AM
Customer quote: “The Lsv3 SKU migrations have greatly helped us lower the cluster costs and improve query performance. C...
743

Cluster monitoring with Keep Alive metric

Gabi Lehner on Nov 14 2022 04:29 AM
Cluster monitoring is essential to guarantee your users can always get performant and reliable service. One of the found...
1,121

How to identify queries send to Kusto from a specific Power BI report

DanyHoter on Nov 08 2022 11:10 PM
You and your team create many PBI reports based that Access Kusto/ADX data. The reports are sending many queries and use...
1,109

New Experience in Query to Power BI from Kusto Explorer/ Kusto web explorer

DanyHoter on Nov 08 2022 10:22 PM
We simplified the process of using a query you wrote in KE or KWE in Power BI or Excel. You no longer need to start with...
1,718

ADX Web updates – October 2022

Michal_Bar on Oct 31 2022 12:40 AM
How do you keep up to date with new features and improvements in ADX Web?
1,712

Azure Data Factory to ADX Free Cluster

ShafMahmood on Oct 23 2022 10:29 PM
If you are using Azure Data Factory and need to connect to an Azure Data Explorer Free Cluster, this walkthrough will sh...
2,108

MS Learn module: Create dashboards in Azure Data Explorer

Tzvia Gitlin Troyna on Oct 23 2022 12:32 AM
Create a dashboard from a query in Azure Data Explorer web UI. Add new tiles. Create dashboard parameters, and cross-fil...
1,880

Kusto Trender

cosh23 on Oct 13 2022 12:00 AM
Read this article if you are interested in timeseries visualization for the IIoT.
1,522

Evaluate query performance of Azure Data Explorer

SuryaJ on Oct 11 2022 12:46 AM
Using load testing tools like Grafana K6 and JMeter, we can test Azure Data Explorer REST API for performance on concurr...
1,283

Use Excel to summarize values from Kusto for a list of Ids

DanyHoter on Sep 28 2022 05:22 AM
Give your Excel user an option to provide multiple Ids and query aggregated values for these IDs from Kusto The data can...
1,140

Kusto Emulator Installation Video

vplauzon on Sep 26 2022 09:23 AM
We just published a YouTube video going step by step through the Kusto Emulator installation process!
1,614

Check it out: Azure Data Explorer MS Learn modules

Tzvia Gitlin Troyna on Sep 21 2022 06:10 AM
What’s a Learn module? A step-by-step tutorial that provide users a free, interactive way to advance their technical ski...
2,525

Azure Data Explorer Quarterly Newsletter (September 2022)

ShafMahmood on Sep 15 2022 05:43 AM
Here is a recap on the latest and greatest features and updates introduced in the last few months. In case you have miss...
1,663

Introducing Conversion Functions in KQL

ShafMahmood on Sep 07 2022 05:28 AM
Great news, the Kusto team have introduced several unit conversion functions to Azure Data Explorer that will help with ...
1,107

Breaking change in window functions

Gabi Lehner on Sep 07 2022 02:41 AM
Azure Data Explorer breaking change in window functions inside partition operator sub-query scope
3,415

Generally available: Kusto Emulator

vplauzon on Sep 06 2022 08:48 AM
We are excited to release the Kusto Emulator, a version of Azure Data Explorer running inside a Docker Container. It is ...
2,386

Scale your Azure Firewall monitoring with Azure Data Explorer

GuillaumeBeaud on Sep 05 2022 07:15 AM
Azure Data Explorer can be used in conjunction with Azure Monitor Log Analytics to store and query logs produced by Azur...
2,418

Return of the Power BI join with Kusto

DanyHoter on Sep 04 2022 07:38 AM
If you followed our recommendations, you avoided relationships between Kusto tables in PBI (In Direct Query) You don't h...
1,818

ADX Web Explorer updates – August 2022

Michal_Bar on Aug 31 2022 04:05 AM
Welcome to ADX Web UI monthly update! New funnel visualization, query tabs management features and .Net and Node.js supp...
2,531

New productivity features in Kusto Explorer

Michal_Bar on Aug 29 2022 11:55 PM
We are pleased to announce new features in Kusto Explorer (Desktop version of Azure Data Explorer web UI) to help you be...
4,697

Azure Data Explorer supports native ingestion from Amazon S3

Anshul_Sharma on Aug 24 2022 01:50 AM
Today we are excited to launch the ability to ingest data from AWS S3 into ADX natively.
1,351

How to create the output schema from Kusto query

ShafMahmood on Aug 01 2022 06:30 AM
If you are using Kusto plugins that require an output schema definition as part of its syntax then it can be tricky to p...
1,566

ADX Web Explorer updates – July 2022

Michal_Bar on Aug 01 2022 01:27 AM
We are pleased to announce a new set of features across all areas of Azure Data Explorer Web UI
1,182

Azure Data Explorer breaking changes [Action Required]

Gabi Lehner on Jul 27 2022 09:19 AM
This notification includes information about 2 upcoming breaking changes in Azure Data Explore service. The changes are ...
2,364

Data pre-processing for Azure Data Explorer with Apache Spark

Hauke Mallow on Jul 19 2022 08:30 AM
To complex historical data? Learn how to do simple data pre-processing with Spark to ingest all your archived data to Az...

Latest Comments

Gilles_LHerault
in Building an Azure Service Tag Lookup utility with KQL and a Free Cluster on Nov 28 2022 06:13 PM
@steffen_zeidler I love the approach! To be honest I was considering doing a "brute force" ingest myself since we know ADX can ingest pretty much anything but I was looking for some excuse to dust off my PowerShell skills :) Next challenge is to poke the service tags REST API that can give us the ta...
0 Likes
steffen_zeidler
in Building an Azure Service Tag Lookup utility with KQL and a Free Cluster on Nov 26 2022 05:46 AM
@Gilles_LHerault wrote:The JSON file available from the download.microsoft site earlier cannot be ingested as is.Ok, I'm curious and tried the challenge. My solution – first ingest the origin file with the format “TXT”. Every text line of the formatted JSON document is now a single row in the Kusto ...
0 Likes
Iris_Kaminer
in Migrate seamlessly your ADX cluster to Lsv3-series for reduced costs and better performance on Nov 24 2022 11:12 PM
Thanks for your inputs. Both L8asv3 and L8sv3 have 1.75TB. The local disks of these SKUs provide better performance than the remotely attached Premium Storage (PS) disks.
1 Likes
wernerzirkel
in Migrate seamlessly your ADX cluster to Lsv3-series for reduced costs and better performance on Nov 24 2022 05:22 AM
it would be nice if the Lsv3 family would provide the +2TB_PS, too
0 Likes
vladtsit
in Send data from Node-RED to free Azure Data Explorer (Kusto) on Nov 20 2022 02:45 AM
Thank you for the manual. This line of code finished with error I was not able to correct. .add database ['<DatabaseName>'] viewers ('aadapp==<Application ID>;<Directory ID>') But anyway, data ingestion is working. What is simplest way to run query against Data Explorer from Node-Red?
0 Likes