How to normalize incoming events in a Stream Analytics job

If you want to normalize the incoming events in a Stream Analytics job and transform records with the following format: Time Id P1 P2 P3 2015-12-16T10:00:01.0000000Z 01 15 30 10 2015-12-16T10:00:01.0000000Z 02 25 40 20 2015-12-16T10:00:01.0000000Z 03 45 18 5 2015-12-16T10:00:01.0000000Z 04 20 23 56 to the following format: Time Id Type Value 2015-12-16T10:00:01.0000000Z 01…

0

How to find absence of signal in a Stream Analytics job

Introduction Recently, I worked at an IoT solution where the customer had to build a Stream Analytics query to check when no data has arrived from a given device in a configurable time window. To solve this problem, the idea is to correlate the data stream containing real-time events (e.g. sensor readings) with device reference…

5

How to implement a partitioned SendBatch method for Azure Service Bus entities

Introduction When a developer tries to use the SendBatch or SendBatchAsync methods exposed by the MessageSender, QueueClient, TopicClient, and EventHubClient classes contained in the Microsoft.ServiceBus.dll, and the batch size is greater than the maximum allowed size for a BrokeredMessage or an EventHub object (at the time of writing, the limit is 256 KB), the method…

6

How to store Event Hub events to Azure SQL Database

Introduction This sample shows how to use the EventProcessorHost to retrieve events from an Event Hub and store them in a batch mode to an Azure SQL Database. The solution demonstrates how the use the following techniques: Send events to an Event Hub using both AMQP and HTTPS transport protocols. Create an entity level shared…

12

Service Bus Explorer 2.6 now available!

I just released an improved version of the Service Bus Explorer tool based on the Microsoft.ServiceBus.dll 2.6.1.0. You can find the code here: MSDN Code Gallery (suggested) GitHub (mostly for developers and contributors) Chocolatey The zip file contains: The source code for the Service Bus Explorer 2.6.1.0. This version of the tool uses the Microsoft.ServiceBus.dll…

14

Service Bus Explorer 2.5 now available!

I just released an improved version of the Service Bus Explorer tool based on the Microsoft.ServiceBus.dll 2.5.3.0. The zip file contains: The source code for the Service Bus Explorer 2.5.2.0. This version of the tool uses the Microsoft.ServiceBus.dll 2.5.3.0 that is compatible with the current version of the Windows Azure Service Bus, but not with…

12

How to create Service Bus queues, topics and subscriptions using a PowerShell script

In my previous post How to create a Service Bus Namespace and an Event Hub using a PowerShell script I provided a PowerShell script to create a Service Bus namespace, an event hub and a custom consumer group. In this post I provide 3 new scripts that you can use to automate the creation of…

11

How to create a Service Bus Namespace and an Event Hub using a PowerShell script

This week I received the same two questions twice from two different customers: how can I create a Service Bus namespace from a PowerShell script? Moreover, after I created the Service Bus namespace, how can I create an event hub from a PowerShell script? The answer to the first question is easy: to create a…

21

Service Bus Explorer 2.3 and 2.1 improved version now available

I just released an improved version of the Service Bus Explorer 2.1 and a new version (2.3) of the tool based on the Microsoft.ServiceBus.dll 2.3.2.0. The zip file contains: The source code for the Service Bus Explorer 2.3.2.0. This version of the tool uses the Microsoft.ServiceBus.dll 2.3.2.0 that is compatible with the current version of…

12

Released listener for queues and subscriptions in the Service Bus Explorer

I just released an improved version of the Service Bus Explorer 2.1 and 2.2. The zip file contains: The source code for the Service Bus Explorer 2.2.1.1. This version of the tool uses the Microsoft.ServiceBus.dll 2.2.1.1 that is compatible with the current version of the Windows Azure Service Bus, but not with the Service Bus…

2