Azure Data Factory and Soap, an opera?

Getting data from an API can be hard, especially when you're trying to get data from a so-called Soap interface. This is a bit of an antique way to distribute data to online applications and has a lot of challenges. I've read a few blogs on this subject but funnily enough, they're all using the … Continue reading Azure Data Factory and Soap, an opera?

Fun ROWNUM() case, get n’th row from dataset.

Last week, one of my coworkers had a nice case. From a dataset, he needed the third row based on an indicator and a timestamp. That sounded a bit vague so I started out with creating a table that contained some records with the columns he'd have to filter on. CREATE TABLE dbo.demo ( id … Continue reading Fun ROWNUM() case, get n’th row from dataset.

Azure SQL Database Performance comparison part 0 of 9: setup

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

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