This month, Steve Jones (T) invites us to write about the way dynamic SQL helped us solve a problem. Case For one of our customers, we've had an interesting case. They have multiple schemas in the database and the schema's contain a lot of tables with different use cases. To grant user groups (not individual … Continue reading T-SQL Tuesday 155, Dynamic SQL
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB General Purpose Serverless tier. Quite a mouth full. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog I wrote about the premium tier, … Continue reading Azure SQL Database Performance comparison part 4 of 9: General Purpose Serverless
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Premium tier. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog I wrote about the standard tier, one that has 9 SKU’s and … Continue reading Azure SQL Database Performance comparison part 3 of 9: Premium
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
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
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
This is the starting point of a series of blogs regarding Azure SQL DB performance. This blog contains the setup and links to all the different database SKU's I've tested so you won't have to scroll endlessly to the part that is of interest to you. I hope you'll find this useful! Click here for … Continue reading Azure SQL Database Performance comparison part 0 of 9: setup
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
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
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
Reitse's blog 