I'm honoured to tell you that I'll be speaking in Oslo this year! I've seen this wonderful city on TV and travelled past it on my way to Hamar for a number of speedskating events. This will be the first time I'll get to visit the city itself. The agenda is brimming with excellent sessions … Continue reading Speaking at Data Saturday Oslo
Tag: Database
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
Speaking at dataMinds Connect 2022!
I'm honoured to tell you that this year, I'm giving a session at the 15th edition of dataMinds Connect. I visited the event last year at the Lamot venue in Mechelen and had a blast. So many good people there. The agenda is brimming with excellent sessions and it's really hard to pick. If you … Continue reading Speaking at dataMinds Connect 2022!
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.
Splitting strings
Splittings string with @SQLServer. #Microsoft #sqlserver #tsql #zekerweten
Clustered Columnstore performance with deletes and updates
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
2021 in review, 2022 in preview
2021 in review. Thank you all! @azure @axiansNL @Azure_Synapse @AzDataFactory @Microsoft #zekerweten #MCT
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
Computed columns acting weird
A fun little problem having to do with calculated columns in a join.









