Clustered Columnstore performance with deletes and updates

One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.

Monitoring Azure SQL with Zabbix

My first long-read about monitoring your Azure SQL DB with Zabbix. And a little bonus with Linux.

Learning ADF part 4

Creating a Pipeline in @azDataFactory with a @AzureSQLDB with CDC enabled as source and a tumbling window. #AzureDataFactory #Azure

Learning ADF part 3

Learning ADF part 3. Created my first dynamic pipeline in @AzDataFactory #AzureDataFactory #learning #sharing #Azure

Computed columns acting weird

A fun little problem having to do with calculated columns in a join.

Learning ADF part 2

Moving data In part one of this series, I've managed to transfer my data from an on-premises SQL Server to an Azure SQL DB. This makes life somewhat easier for the next steps. The Azure SQL DB will play the role of my main production server. The one that will serve as source for my … Continue reading Learning ADF part 2 →

Learning ADF part 1

I'm learning ADF. I know the basics of what it does, but I'm in no way really knowing of what to do. In this blog series I'll try and record the steps I've followed to get to grips with basics and maybe more. Transferring your data from on premises to Azure I'm assuming you've got … Continue reading Learning ADF part 1 →