The Fabric servive Eventstream can read data from an Event Hub service to help collect data from IoT devices and other streaming services. But how do you configure the Event Hub and Eventstream to work together? I’ll try to help with that in this blogpost. Start and configure the Event Hub First of all we need an Event Hub in Azure. The process is quite easy. Choose to create a new service and search for the Event Hub service.
With the release of Microsoft Fabric, we also got the ability to use the Kusto engine in the platform. Not only can we now use our Kusto database and all the great stuff from the KQL language - we can also store KQL querysets and use those on our reporting platform. The new magic All of the above abilities are great additions to the Fabric service. But whats even more exciting is the new magic in Jupyter Notebooks.
This week is going to be very technical. I’ve also learned something new by writing this post and I hop eyou will too. The Azure Data Explorer team has released a set of new functionality to help with clustering on data using a Log Reduce approach. The “old” approach Before the release described below - the ADX service had a good handfull of features to help with anomaly detection and clustering on semi structured data.
This months T-SQL Tuesday is number 161 and is hosted by Reitse Eskens (T, L, B) - you can read the original invitation here or by clicking the image below. The topic of this month is about our most fun T-SQL script. It can be either a procedure or statement that I’ve written. My fun T-SQL script A couple of years back I needed to find the latest used parameters from a reporting services - SSRS (yes, it is old!
This week it is almost Easter and time for cozy and relaxing time with the family. Relaxing time is also a part of this post, as I will show you some of the different meta-data options you have in Kusto and what to do with them. The main meta data part in Kusto In Kusto and the services Azure Data Explorer and Synapse Data Explorer, there is one main part of the meta data queries - the .
In todays post I’ll dive into the choice between the options when creating the clusters for Azure Data Explorer. The underlying architecture for the Kusto/ADX clusters is build on virtual machines (VM) with specific configrations. Dev/test vs production When creating the clusters from the Azure portal, you are presented with 3 options when choosing the compute specification. The compute specification is the method of setting up the clusters for the specific workload you are planning to put on the Kusto cluster.
Kusto cannot stand alone When using Kusto and Azure Data Explorer the service cannot stand alone. It needs some data to give it value. This blogpost tries to give some inout on the two IoT services som Azure that seamlessly integrates with the Azure Data Explorer (there is more, but to narrow it down 😄). Azure IoT Hub vs Event Hub When working with Azure Data Explorer and loading data to the storage engine, you might have some streaming devices or services that should land in the engine.
This months T-SQL Tuesday is number 160 and is hosted by Damien Jones (T, L, B) - you can read the original invitation here or by clicking the image below. The topic of this month is really interesting as we are to discus our personal wishlist for the partnership between Microsoft and OpenAI. As I’m a SQL and Kusto guuy to the bone, this will also be my stepstone in this blogpost.
Do you want to learn Synapse Data Explorer and do you want to read only one book about it? Then you should read the book by Pericles (Peri) Rocha (Li) - Learn Synapse Data Explorer. The writer Peri Rocha is a Senior Product Manager for Azure Synapse Analytics from Microsoft. He shows a great knowledge in the book around Synapse Data Explorer and the way of working with KQL in the services.
This months T-SQL Tuesday is number 159 and is hosted by Deepthi Goguri - you can read the original invitation here or by clicking the image below. The topic of this month is two fold: Favorite feature from SQL Server 2022 or SQL server in Azure What is my new year resolution and how to keep the discipline My favorite new feature in SQL server. This must be the new Optimized Locking feature released to Azure SQL Database.