Author: reitsees

Reitse began his computer days with GW Basic and quickly followed with Windows 3.11. After that many computers followed and, interrupted by human resource and psychology studies, he got into the IT work field around 2007. There he met Oracle 9. With a command line from 1980. At his current job he met SQL Server. And loved it. Now he’s working with SQL 2008 to SQL 2019 on-premises and a number of Azure SQL Databases, supporting customers and tuning databases. New projects focus more on the Azure data platform as an architect, security advisor and data engineer.

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 →

Speaking at Pass Data Summit

I'm honoured to be chosen to speak at the enormous Pass Data Summit. I'll doing a virtual session but will leave plenty of time in and after the session for Q&A. The schedule isn't finished yet so I've got no idea what other sessions will be taking place in my timeslot, but seeing some mentions … Continue reading Speaking at Pass Data Summit →

Speaking at Data Saturday Oslo

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 →

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! →

Speaking at DataWeekender and SqlFriday

A short blog about my latest speaking experiences #dataweekender #sqlfriday #zekerweten

#TSQL2sday #149  T-SQL Advice you’d give to your younger self

This month, Camila Henrique (b | L) invites us to write about advice for our younger selves. In one simple line it'd be 'follow your heart'. After finishing school I had to choose my next level education. I wasn't qualified (yet) to go to university so I went to the next best level. Because I … Continue reading #TSQL2sday #149  T-SQL Advice you’d give to your younger self →

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