Azure
-
From Warehouse To Lakehouse – ELT/ETL Design Patterns With Azure Data Services
I like a good pattern. I also like a good framework. From a data perspective, nothing lends itself better to having both of these as ETL/ELT. For those not familiar…
-
Code Free Batch Scoring with Azure Synapse Analytics and Automated Machine Learning
Azure Automated Machine Learning is an awesome tool. It significantly lowers the bar of entry for data science by allowing folk to submit their datasets to the service, tell it…
-
Extracting data from the Microsoft Bookings API (and any others) with Azure Data Factory
The rise of remote working has come as no surprise in the last year for obvious reasons. From a Microsoft perspective, this has seen the massive growth in use of…
-
Data Virtualization With SQL Server 2019 Big Data Clusters
**NOTE** Whilst this post refers to SQL Server 2019 Big Data Clusters, which requires signing up to the private preview, for those who don’t need the HDFS features and just…
-
Extract, Transform & Load Options In Azure
Extract, Transform & Load (ETL), or ELT, ETLT or whatever term we use nowadays, has been around for many decades. In terms of “what it is” – although I’m sure…
-
Migrating Your SQL Server Estate To Azure
Many customers want to move their SQL Server databases into the Azure cloud. Whilst not discussed here, moving to a PaaS (Platform As A Service) database platform provides many benefits…
-
Loading Multiple Tables With Azure Data Factory
There arn’t many articles out there that discuss Azure Data Factory design patterns. One big concern I’ve encountered with customers is that there appears to be a requirement to create…
-
Building The Data Warehouse-less Data Warehouse (Part 2 of 2)
Part 1 of this series can be found here. In my previous post I discussed and explored the feasibility of building a simplified reporting platform in Microsoft Azure that did…
-
Introducing The Azure Data Architecture Guide
Designing data-centric solutions in the cloud can be a challenge. Not only do we have the standard challenge of meeting customer requirements, but we also have to deal with an…
