SQLBits 2020

Migrating my favorite past project from On Premise to Azure

A few years ago I had a client with a data need and I built an IaaS solution. Now, it would have been an ideal fit for a PaaS approach using Azure DB, Stream Analytics and Power BI. This session demos and explains why.

This short session is a hands-on demo of how I migrated a solution from IaaS to PaaS. The original solution used FTP, SSIS, SQL DB, and Reporting Services based. The need was a perfect fit for a PaaS approach based on Event Hubs, Stream Analytics, Azure DB and Power BI. I explain why and demo how I built the new solution.

Speaker

A seasoned data professional with 20+ years of experience in SQL Server/Analysis Services and related technologies. Leader of the Cork SQL and Power Platform User Groups and the Cork SQL Saturday and a regular speaker at user groups in Ireland.

Mark Hayes's Sessions

Avoiding Turbulent Skies: Power BI Security Strategies for a Smooth Flight

"Beyond the barchart". Some top picks from "Get More Visuals" to enhance your reports

0 to an fully functional teams bot in 20 minutes!

Rebooting your SME Data Analysis Strategy

Migrating my favorite past project from On Premise to Azure