One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
Clustered Columnstore performance with deletes and updates
Category: DBA
Azure Infrastructure as Code
If you've been working with Azure for more than a few months, you'll find that deploying resources with the portal is a tedious, time consuming and, at times, a frustrating excercise. It's the best starting point you can get, because the portal will show you a lot of options and offers a easy learning curve. … Continue reading Azure Infrastructure as Code
Speaking at Pass Data Community Summit
A few remarks and observations on speaking at #PassDataCommunitySummit
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!
Monitoring Azure SQL with Zabbix
My first long-read about monitoring your Azure SQL DB with Zabbix. And a little bonus with Linux.
Learning ADF part 3
Learning ADF part 3. Created my first dynamic pipeline in @AzDataFactory #AzureDataFactory #learning #sharing #Azure
Computed columns acting weird
A fun little problem having to do with calculated columns in a join.
Learning ADF part 2
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
T-SQL Tuesday #139: The data world is hybrid
This month, Ben Weissman (b|t) invites us to write about the experiences in the hybrid data world and to tell where we are in our journey. To start with the latter, I'm only just beginning the journey. Most of our clients are running on-premises or are thinking about moving to the cloud. But the first … Continue reading T-SQL Tuesday #139: The data world is hybrid
Reitse's blog 