Speaking at Data Saturday Gothenburg

In a few weeks, I'll be speaking in Gothenburg at the Data Saturday event. I've driven past Gothenburg earlier this year on my way to Hamar but didn't get the chance to stop there (other than a traffic jam ;)). As a long-time Volvo and Stiga driver, it's nice to visit the home country of … Continue reading Speaking at Data Saturday Gothenburg

Increase network performance between your VM and Azure SQL Database

For a few weeks I'm facing an issue where an application on an Azure VM has a slow network connection to an Azure SQL database. I've tried different tiers and SKU's but the speed is just not there. When the application is running, it can push about 250 to 500 kb/s to the database. As … Continue reading Increase network performance between your VM and Azure SQL Database

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.

Preceding and following, can you use them in one statement?

Testing out if you can use preceding and following in the same windowing function @Microsoft @SQLServer #zekerweten

Attending, helping and speaking at SQL Bits 2022

All my experiences at #sqlbits. Spoiler alert: I loved it!

T-SQL Tuesday #147: Upgrade strategies

My short thoughts on migrating/upgrading SQL Server for #tsql2sday #tsql2sday147

Splitting strings

Splittings string with @SQLServer. #Microsoft #sqlserver #tsql #zekerweten

Speaking at data TGIF

Long overdue blog reflecting at my experience when speaking at dataTGIF