Azure SQL and IoT | Data Exposed

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 scaleAdditional Resources:Azure IoT reference architectureStreaming At Scale - Azure SQLIngesting 10K events/sec VideoJSON Performance in Azure SQL