Microsoft Fabric, Data Warehouse first impressions

When Fabric released, there was a lot of noise around it. Many people have written blogs, created YouTube video's and all kinds of other interesting things to share the love of this new tooling. Well, new? Especially when you look at Fabric data warehouse, it's more of an iteration over Synapse Analytics Serverless Pools. As … Continue reading Microsoft Fabric, Data Warehouse first impressions

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.

Splitting strings

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

Oh no, I’ve lost my query window

How to find your lost query files from SSMS.