Background Building on a previous blog post where I explored what a possible Azure Synapse Analytics logical architecture might look like in terms of end-to-end data curation/enrichment, here: Thinking about an Azure Synapse Analytics Logical Architecture v1 Now, with the recently added Synapse 'Managed Virtual Network' I'm exploring the same architecture from a physical network connectivity … Continue reading Thinking About an Azure Synapse Analytics Physical Architecture v1
Hi folks, as some of you may be aware it was the Microsoft MVP Summit in March, for MVP's this is an exciting time where Microsoft product teams share plans for the coming year and talk about features on the roadmap. That said, I have the privilege of knowing what the future looks like for … Continue reading Thinking about an Azure Synapse Analytics Logical Architecture v1
Azure Data Analytics End to End Let's start with a story, not a 'once upon a time story', a story for your backlog 🙂 As a solution architect I need to design and build an Azure data analytics platform end to end to deliver data insights for my customer. In February 2021 I delivered a … Continue reading An Architects Guide to Delivering Data Insights Using the Microsoft Azure Data Platform
Microsoft Ignite 2021 Announcements Another Microsoft Book of News, this time from Ignite 2021. Thanks Microsoft, really handy having all the announcements in one place. Not loads of Data & AI things shared at this event. But still 55 pages of some impressive additions to the Microsoft products. My favourite bits as a Data Platform … Continue reading Microsoft Book of News – Ignite 2021
A few weeks ago I delivered an introduction session on Azure Synapse Analytics as part of the Data Toboggan event. In my session I explored what Synapse is? And given the answer isn't that straight forward or obvious I thought it was probably worth re-sharing here as the recording is now available on YouTube. In … Continue reading What is Azure Synapse Analytics?
Last Updated - 28th may 2021 Following my previous (more detailed) blog post on 'Is Azure Synapse Analytics Ready for Production?' I was asked to summarize this understanding/opinion of Synapse into a simpler view. Updated: I've tweaked a couple of the traffic lights and narrative based on the annoucements this week from the Microsoft Build … Continue reading Azure Synapse Analytics – Feature Summary vs Status
It's now been well over a year since Microsoft announced Azure Synapse Analytics as an offering at the big U.S.A based conferences back in November 2019. While I completely share and actually like Microsoft's vision of an analytics resource... "that brings together data integration, enterprise data warehousing and big data analytics" https://azure.microsoft.com/en-gb/services/synapse-analytics/ ... the marketing, … Continue reading Is Azure Synapse Analytics Ready for Production?
Databricks vs Synapse Analytics As an architect I often get challenged by customers on different approach's to a data transformation solutions, mainly because they are concerned about locking themselves into a particular technology, resource or vendor. One example of this is using a Delta Lake to deliver an Azure based warehousing/analytics platform. Given this context, … Continue reading How Interchangeable Are Delta Tables Between Azure Databricks and Azure Synapse Analytics?
New & Updated Talks for the Community With 2020 in the rear view mirror its time to reflect on another year of experience gained as a consultant designing and delivering data platform solutions for my customers in this every changing world of technology. I've previously confessed that my job is my hobby, so its great … Continue reading Preparing My Community Talks for 2021
Azure Data Factory & Azure Synapse Analytics Integrate Pipelines In this post I want us to explore and understand the difference between an internal and external activity when using our favourite orchestration pipelines. I'll focus predominately on Azure Data Factory (ADF), but the same applies to Azure Synapse Analytics. *Warning: this is a fairly dry, … Continue reading Pipelines – Understanding Internal vs External Activities