Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Standard tier. Click here for information about the set-upClick here for the scripts I’ve used Intro This tier is more expensive than the basic, but starting at 12 euro’s per month up … Continue reading Azure SQL Database Performance comparison part 2 of 9: Standard
Tag: SQL
Azure SQL Database Performance comparison part 1 of 9: Basic
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Basic tier. Click here for information about the set-upClick here for the scripts I’ve used Intro This tier is the cheapest one around, it'll cost you about 5 euro's per month. This … Continue reading Azure SQL Database Performance comparison part 1 of 9: Basic
Speaking experiences at Data Saturday Oslo
This weekend, I had the honor of speaking in Oslo at the data saturday event. Hosted by Johan Ludvig Brattas, Rune and a number of other key people, they have created a very welcoming atmosphere. Friday The event started with the speaker dinner on friday evening. As I had flown in early, I had explored … Continue reading Speaking experiences at Data Saturday Oslo
Speaking experiences at Data Saturday Göteborg
Last saturday I was speaking in Göteborg at the local data saturday, hosted by Mikael Wedham (T | B). The day before a speaker dinner was organised at an island with a very nice restaurant. After a boat ride of about an hour (where we picked up some late arrivals along the way) we got … Continue reading Speaking experiences at Data Saturday Göteborg
Speaking at Data Saturday Gothenburg
In a few weeks, I'll be speaking in Gothenburg at the Data Saturday event. I've driven past Gothenburg earlier this year on my way to Hamar but didn't get the chance to stop there (other than a traffic jam ;)). As a long-time Volvo and Stiga driver, it's nice to visit the home country of … Continue reading Speaking at Data Saturday Gothenburg
Increase network performance between your VM and Azure SQL Database
For a few weeks I'm facing an issue where an application on an Azure VM has a slow network connection to an Azure SQL database. I've tried different tiers and SKU's but the speed is just not there. When the application is running, it can push about 250 to 500 kb/s to the database. As … Continue reading Increase network performance between your VM and Azure SQL Database
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









