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: SQL
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.
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 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









