Category: Azure

Speaking at Microsoft Data Platform Group – Birmingham

Next week (Thursday 4th of august 2022) I've been invited to speak at the Microsoft data platform group Birmingham. This is a very active user group that hosts monthly sessions on the data platform, and this month I'm honoured to talk about monitoring Azure SQL with Zabbix. In this session I'll walk you through monitoring, … Continue reading Speaking at Microsoft Data Platform Group – Birmingham →

Connect your on-premises SSMS to Azure SQL DB over a VPN

Now that's a title! Here's the problem I've ran into. Setup Customer has an Azure environment with an Azure SQL Server database that can be reached through a private endpoint. There's a VPN in place to connect on-premises networks with the Azure VNet and the private endpoint is in one of the subnets, the VPN … Continue reading Connect your on-premises SSMS to Azure SQL DB over a VPN →

Solving an issue with Always Encrypted

A short blog on how to get Always Encrypted to work in your app and in the ODBC connection.

Azure Infrastructure as Code

If you've been working with Azure for more than a few months, you'll find that deploying resources with the portal is a tedious, time consuming and, at times, a frustrating excercise. It's the best starting point you can get, because the portal will show you a lot of options and offers a easy learning curve. … Continue reading Azure Infrastructure as Code →

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

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 →