Azure Stream Analytics is a fully managed serverless offering that enables customers to perform real-time data transforms and hot-path analytics using a simple SQL language. In this session, we will show how to combine SQL reference data to augment data coming from devices and create real-time alerts, leverage partitioning to write data to SQL at high speed, and create real-time dashboards.