One of the downfalls of Azure Data Explorer is that it lacks built-in functionality to backup & restore databases. At least not in the way we know it in SQL server. A solution that might solve the problem is using on-demand data recovery. In this article, I will investigate this solution and how it performs with large datasets.
Free in-person workshop “Experience the basics of Azure IoT, Dashboarding … and beyond” at BitBash
On January 26, 2024 Sander van de Velde and I, will organize the workshop “Experience the basics of Azure IoT, Dashboarding … and beyond” at Bitbash.
Within this free workshop, you will get an idea of the basic IoT principles by hands-on experience with a cloud connected coffeemaker, Azure IoT and Azure Data Explorer. So, bring your laptop and prepare yourself for future IoT projects.
How to deal with Change Data Capture in Azure Data Explorer – Part 2
In part 2 of the series about Change Data Capture (CDC) in Azure Data Explorer, we look at another approach on how to handle data when only changes from the device to the cloud are sent.
How to deal with Change Data Capture in Azure Data Explorer
Change Data Capture (CDC) is a design pattern to only track the changes in data. There are several ways this could be implemented. In IoT solutions, the Change Data Capture (CDC) pattern is used, to only send changes from the device to the cloud. But how to deal with this data in Azure Data Explorer for further analysis?
Authorize a Storage Account by Attribute-based access control (ABAC)
How to add authorization to an Azure Storage Account based on attributes. Attribute-based access control (ABAC) builds on role-based access control (RBAC) by adding conditions to Azure role assignments.
Geographic information in Azure Data Explorer
Located someone in Azure Data Explorer with the use of a function and a scatter plot based on an IP-address.
Ingest historical data into Azure Data Explorer
What if you have an Azure IoT solution and recently added Azure Data Explorer (ADX), and you also want to ingest your historical data. Then LightIngest might be the solution, a lightweight tool for importing data into Azure Data Explore.
Integrate Azure Data Explorer dashboards into Azure DevOps
It is possible to create an Azure Data Explorer cluster using ARM or Bicep templates. The only thing lacking is the ability to integrate ADX dashboards into Azure DevOps enabling Continuous Integration / Continuous Delivery, or is it?
Automatically deploy (layered) deployments to Azure IoT hub
Automatically deploy (layered) deployments to Azure IoT hub using Infrastructure as code (IaC). Because it makes your IoT hub deployments repeatable and more consistent.
Setting up a IoT hub with Bicep
How to create an Azure IoT hub with Bicep. But what is Bicep anyway and why should we use it. In this article, I will explain about Bicep and we will create a simple Bicep example to deploy an IoT hub.