Azure
-
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 1 of 2)
*Update – part 2 of this series is now live, and can be found here* In times of yore, those who maketh the houses of data would bring forth vast…
-
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…
-
SQL Server Options In Azure
The data platform options in Azure are vast, and they grow and change with each month. Choosing the right database platform for your workloads can be a challenge in itself.…
-
Getting Started with SQL Operations Studio
I’m a fan of new shiny things, and as a former SQL Server DBA the release of SQL Operations Studio definitely peaked my interest. So, in the words of the…
-
Incremental ETL Processing With Azure Data Factory v2
Data Factory V2 was announced at Ignite 2017 and brought with it a host of new capabilities: Lift your SSIS workloads into Data Factory and run using the new Integrated…
-
Power BI Premium Vs Analysis Services
What? Is that even a valid question? At first glance this isn’t an obvious topic, but I’ve had a couple of conversations recently with partners that echoed some of my…
