Azure SQL and IoT | Data Exposed

From the creator

IoT is almost always associated with NoSQL database. This is quite understandable as its flexibility and specialization are great for ingesting IoT data. But what if that flexibility and performance are also available in Azure SQL? That would make Azure SQL a perfect target for IoT data as along flexibility and performance you have security, manageability, analytics, and scalability. In this episode, Davide Mauri discusses all this and more - and shows you why Azure SQL is a great option for IoT and HTAP. [01:14] IoT architecture [02:15] Features [02:35] Columnstore [02:42] Rowstore [02:55] Read-scale out [03:40] Memory-optimized (lock free) structures [04:02] JSON support [06:50] Create your own Lambda/Kappa architecture in Azure [09:00] What you can do with the data at this scale ✔️ Additional Resources: Azure IoT reference architecture: https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/iot-with-sql?WT.mc_id=dataexposed-c9-niner Streaming At Scale - Azure SQL: https://github.com/Azure-Samples/streaming-at-scale/tree/master/eventhubs-streamanalytics-azuresql?WT.mc_id=dataexposed-c9-niner Ingesting 10K events/sec Video: https://www.youtube.com/watch?v=vVrqa0H_rQA?WT.mc_id=dataexposed-c9-niner JSON Performance in Azure SQL: https://devblogs.microsoft.com/azure-sql/json-in-your-azure-sql-database-lets-benchmark-some-options/?WT.mc_id=dataexposed-c9-niner 📌 Let's connect: Twitter - Davide Mauri, https://twitter.com/mauridb Twitter - Anna Hoffman,

Published 2020-07-16 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.