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…


Query Pattern of the Week: Use expressions inside a TIMESTAMP BY clause

Azure Stream Analytics allows expressing complex event processing rules using a simple SQL-like query language. Given the temporal nature of Stream Analytics queries, it is important to specify a timestamp for every input event.  By default, Stream Analytics will use arrival time of the input event – e.g. if Event Hub is used as an…

0

Azure Stream Analytics @ The First Ever Cortana Analytics Workshop!

The Azure Stream Analytics (ASA) team was proud to be a part of the first ever Cortana Analytics Workshop that was held September 10-11, 2015. The 2-day event was sold out, we had around 700 attendees, around 500 customers/partners from 293 companies and 35 countries (almost 1 in 5 attendees were non-US). For those newly…

1

Common Stream Analytics Query Patterns

We have received many questions and requests for help from customers who aren’t sure how to write their stream processing logic in the Stream Analytics Query Language.  We are happy to announce that we have released a guide that captures common query patterns and describes them fully with sample data, code snippets, and explanations: https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-stream-analytics-query-patterns/…

0

February Updates to Azure Stream Analytics

 We are pleased to share that the latest Azure Portal update brings several new Stream Analytics features.   Resume stopped jobs To enable resuming stopped jobs without data loss, we added an option on Start to bring the job back up from the Last Stopped Time. Support for Table Storage output In addition to SQL Database, Event Hub,…

0

Stream Analytics Hands On Lab

We have been getting a lot of request around providing a Hands On Lab for Stream Analytics. Today we are happy to announce that we have published our Hands On Lab materials and its sample code and you can download it from GitHub. Event-driven processing through declarative, long-standing queries is a fundamentally different paradigm than…

0

How To: Query for ‘All’ events and ‘No’ event scenarios

All and Nothing Azure Stream Analytics aspires to make low-latency, near-real-time stream computations as easy to use as typing a SQL query.  But while SQL (and its Stream Analytics dialect) is a powerful language, there are some “tricks of the trade” to quickly and easily expressing common stream-analytic concepts. Today, we look at two common…

0

Azure Stream Analytics used in Healthcare

Interested in seeing how our customers use Azure Stream Analytics to derive real time insights into their data in the Health care sector?   News article:  http://www.cio.com/article/2852000/healthcare/internet-of-things-helps-asthma-patients-breathe-easily.html You can find the complete case study here:  https://customers.microsoft.com/Pages/CustomerStory.aspx?recid=12216   Do you have a scenario you would like to collaborate with the product team to light up?  Contact…

0