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