Reference data is a dataset that is static or slow changing in nature which you can correlate with real-time data streams to augment the data. Azure Stream Analytics leverages versioning of reference data to augment streaming data by the reference data that was valid at the time the event was generated. One of the most popular customer requests is to be able to use Azure SQL Database as reference data input for Stream Analytics.
We are excited to announce that this capability is now available in public preview.
For more information and to get started with using Azure SQL Database as your reference data set for Azure Stream Analytics, see this announcement.