SQL Saturday Nashville – January 2020

I will be speaking at SQL Saturday Nashville on Saturday, January 18th at 8:30 am. The topic is: Data Bricks, Spark, Machine Learning and Azure Synapse Analytics An end-to-end example of Data in the cloud. You've heard about Azure Data Lake and Azure Data Warehouse, now called Azure Synapse Analytics. You've also heard about Azure … Continue reading SQL Saturday Nashville – January 2020

Quickly Processing One Million Transactions in Azure SQL Database

I've had to solve an interesting problem this week. I started the week with an SSIS package that ran in 2 minutes. It extracts a million transaction records from DB2 to a file, uploads the file to Azure Blob Storage and BULK IMPORT's the file into an Azure SQL Database staging table. All in 2 … Continue reading Quickly Processing One Million Transactions in Azure SQL Database

Azure Data Factory Publishing Error

I am using Azure Data Factory v2. It is bound to an Azure DevOps GIT repository. I made some changes in my branch, including deleting some obsolete items. Then I merged my changes back to the 'master' branch. Now, I'm trying to publish my changes from the 'master' branch to the Azure Data Factory. When … Continue reading Azure Data Factory Publishing Error