Blog Pause

Hey friends, for the time being I will be pausing the content pushed to this blog. Everything on the site will remain unchanged and mrpaulandrew.com will continue as my own brand, including social media handles etc. However, going forward I will be focusing my efforts and thinking on the Cloud Formations blog. Please join me … Continue reading Blog Pause

Data Integration, Architecture and Real-Time Analytics Full Training Days with Me 2024

SQL Bits, UK, go to >> SQL Day, Poland, go to >> Data Platform Next Steps, Denmark, go to >> Big Data Europe, Lithuania, go to >> SQLBits | March | Online & In Person Microsoft Data Integration Pipelines – The Fundamentals to Level 300 Event Link: https://sqlbits.com/attend/the-agenda/full-day-training/Microsoft_Data_Integration_Pipelines__The_Fundamentals_to_Level_300 Overview In this full day of training, … Continue reading Data Integration, Architecture and Real-Time Analytics Full Training Days with Me 2024

Is Azure Synapse Analytics Dead and Does It Really Matter?

The product vs the capabilities I think it’s fair to say that Azure Synapse Analytics has had a hard life. It was announced in public preview as a surprise to most of the community, including Microsoft cloud solution architects. Ultimately meaning that very little private preview testing and feedback on the product was done before … Continue reading Is Azure Synapse Analytics Dead and Does It Really Matter?

Would you like me to review your data platform architecture?

Hi, I'm Paul and I've been designing and delivering Microsoft data platform solutions for around 15 years now. I've seen it all. The good, the bad and the ugly (for the Clint Eastwood fans). During my career I've worked with customers big and small, national and international, covering almost every industry vertical. I've also been … Continue reading Would you like me to review your data platform architecture?

procfwk is Getting An Upgrade to CF.Cumulus

CF.Cumulus.Control Early Release Running a company (Cloud Formations) is very much a balance between steering the ship, while building the ship! As a result, my open source metadata driven orchestration framework (procfwk.com) got neglected. To the point where the Azure Functions, the middleware, originally written in .Net 3.1 Core is no longer supported. Additionally, the … Continue reading procfwk is Getting An Upgrade to CF.Cumulus

SQLBits 2024 – My Sessions

This year at SQLBits I'm once again honoured to be presenting a full training day, a 100 minute session and a regular session during the week. It'll be my 8th time at SQLBits and my 4th time delivering a full training day. Full agenda here: https://sqlbits.com/attend/the-agenda My Hat-Trick Of Sessions Microsoft Data Integration Pipelines – … Continue reading SQLBits 2024 – My Sessions

Ending 2023 On A High With Two Microsoft Fabric Projects Delivered

Walking the Walk With Real-Time Analytics I hope you enjoyed 2023 as much we have. Founding my own data consultancy business with Dan was certainly a highlight. But then, to put that machine, that experience and that passion for technology into practice, delivering not one, but two customer projects is simply the best feeling. And … Continue reading Ending 2023 On A High With Two Microsoft Fabric Projects Delivered

Considering a Medallion Architecture vs Microsoft Fabric

Data Ingestion vs Data Serving Context It seems like the concept of a medallion architecture has stuck in the industry. ETL isn't cool anymore and decribing the layers of our data solution directly with names like raw, cleansed and modelled was (apparently) too obvious, or maybe too interchangable, meaning people couldn't agree. That's fine. I … Continue reading Considering a Medallion Architecture vs Microsoft Fabric

Getting Hands On With Microsoft Fabric

The Pain Of Creating Production Solutions With Preview Tools Over the last couple of months we've been involved in the design and build of a real-time analytics platform where Microsoft Fabric has been front and center for the delivery. After a lot of debate during the design phase, it was concluded that using Microsoft Azure … Continue reading Getting Hands On With Microsoft Fabric