Migrating my favorite past project from On Premise to Azure

on YouTube ↗18m

" summary

Migrates an IaaS pipeline (VM web service + file drops + SSIS + SQL Server + SSRS) to a PaaS flow using Azure Event Hub -> Stream Analytics -> Azure SQL Database -> Power BI, replacing days of setup with one Stream Analytics query that tumbling-window aggregates every 10 seconds. Demo sends ~120 simulated MAC events, Stream Analytics writes grouped counts to SQL and Power BI successfully, and streaming units can scale from 1 up toward 192 for capacity planning.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 4:20Event Hub
3. 4:50Stream Analytics
4. 12:12Power Bi
5. 14:41Summaries and Conclusions

" related talks

• 44mSmart application on Azure at VattenfallRens Weijers, Peter van 't Hof · GoDataFest 2019
• 39mMigrating a data stack from AWS to Azure #bbuzzDániel Molnár · Berlin Buzzwords 2016
• 50mPower BI + Azure Synapse Analytics: Beginning your journeyPatrick LeBlanc, Adam Saxton · SQLBits 2023
• 51mLightup your Mobile Apps with AzurePraveen Srivatsa · Great Indian Developer Summit 2015
• 50mBest practices for implementing a modern data architecture with AzureElvis D'Souza, Raheel Retiwalla · Global Summer 2020 Azure Data Fest 2020
• 16mReal-Time Solution for Critical Data Migrations and IntegrationsEdward Bell, Elisabeth Dornbrach · Microsoft Build 2023
• 51mSupercharge Power BI with Azure Synapse AnalyticsMathias Halkjaer · SQLBits 2023
• 41mA Case Study - Data Movement and Transformation using Azure Data FactoryALPA BUDDHABHATTI · Data Con LA 2021