Querying JSON array with Azure Stream Analytics

Kent Weare has written a nice post on querying Json array with Azure Stream Analytics. He is getting device reads off of an Azure Event Hub. These reads are being aggregated on the publisher side and placed into a single message/event. Since the publisher is creating a message structure that contains many device reads for that specific interval Kent…


Stream Analytics query to check when no data has arrived from a given device in a configurable time window

Paolo Salvatori describes well here how you might write 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 data. Thanks again Paolo for…


Tumbling, Sliding and Hopping Windows with Azure Streaming

I found these series of posts by @DesertIsleSQL very well written describing Tumbling, Sliding and Hopping Window functions in Azure Streaming queries. Incorporating Azure Streaming Analytics with Azure ML – Part 1 Using Tumbling Windows to Select Data from Azure Stream Analytics – Part 2 Azure Stream Analytics Hopping – Part 3    


How do I transform incoming events using Stream Analytics?

Question: The data that arrives from the devices will have the format Time, Id, P1, P2, P3. Can this be transformed using SA to the other/vertical format and stored to SQL? This interesting question was asked by one of our users recently and our good friend Paolo Salvatori has put up a well written solution…


VMob’s cool retail sales boosting IoT solution

We are very excited to share an interesting solution built by one of our customers VMob . New Zealand-based VMob is harnessing IoT to help McDonald’s transform its customer engagement in the Netherlands, Sweden and Japan, regions that represent about 12 percent of the food service retailer’s locations worldwide. With VMob, McDonald expanded its existing…