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
Tag: SQL SERVER
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
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
Clustered Columnstore performance with deletes and updates
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
How the DAC saved the day
How using the DAC saved our day!
Monitoring Azure SQL with Zabbix
My first long-read about monitoring your Azure SQL DB with Zabbix. And a little bonus with Linux.









