22-25 April 2026
Video unavailable
SQLBits 2022

Stream processing in SQL with Azure Stream Analytics

Azure Stream Analytics offers real-time stream processing in SQL. In this session we'll discuss what differs between a T-SQL query and a streaming one in ASA.
You know SQL? You need to process data in real time? Azure Stream Analytics (ASA) is the service for you. But let's dig a bit deeper and understand what makes a streaming query in ASA different from a T-SQL one in SQL Server. In this session we'll discuss: - the temporal aspect of stream processing, in theory and how it's implemented in ASA via time skew policies, windowing and how timestamps evolve as data flows through queries, - how best to scale ASA jobs via partitioning, - and how dynamic typing works in ASA, to never get bitten again inserting data in a SQL database