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
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
A short blog on how to get Always Encrypted to work in your app and in the ODBC connection.
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
Reading data from an API into parquet files with @AzDataFactory #azure
How using the DAC saved our day!
Creating a Pipeline in @azDataFactory with a @AzureSQLDB with CDC enabled as source and a tumbling window. #AzureDataFactory #Azure
Learning ADF part 3. Created my first dynamic pipeline in @AzDataFactory #AzureDataFactory #learning #sharing #Azure
Moving data In part one of this series, I've managed to transfer my data from an on-premises SQL Server to an Azure SQL DB. This makes life somewhat easier for the next steps. The Azure SQL DB will play the role of my main production server. The one that will serve as source for my … Continue reading Learning ADF part 2
I'm learning ADF. I know the basics of what it does, but I'm in no way really knowing of what to do. In this blog series I'll try and record the steps I've followed to get to grips with basics and maybe more. Transferring your data from on premises to Azure I'm assuming you've got … Continue reading Learning ADF part 1