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?
Category: ETL
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
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.
Clustered Columnstore performance with deletes and updates
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
Learning ADF Part 5
Reading data from an API into parquet files with @AzDataFactory #azure
How the DAC saved the day
How using the DAC saved our day!
Learning ADF part 4
Creating a Pipeline in @azDataFactory with a @AzureSQLDB with CDC enabled as source and a tumbling window. #AzureDataFactory #Azure
Learning ADF part 3
Learning ADF part 3. Created my first dynamic pipeline in @AzDataFactory #AzureDataFactory #learning #sharing #Azure