-
Building A Logical Data Warehouse With Azure Synapse Analytics
In a previous post I blogged about “Building the Datawarehouse-less Datewarehouse“, which is pattern I’ve always liked wherein we can build a logical star schema across a raw data lake…
-
Automating Synapse Analytics Compute Management With Azure Data Factory
Note – whilst I use the term Azure Data Factory in this article, the approach is supported by both Azure Data Factory AND Synapse Pipelines inside your Synapse Workspace Pausing,…
-
Adding new python libraries to azure synapse spark pools
This is just a short post, but it’s a prelude to a larger one I’m writing on record-linkage using Synapse Spark Pools with this step being a requisite. Synapse Spark…
-
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…
-
SQL of the North – An Update
It’s been almost a two year absence since my last post on SQLoftheNorth. Nothing sinister has happened at all, however I’ve been in a different role that didn’t allow for…
-
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…
Lakehouses, data & AI
