Here is the full document that I referred to in the Seminar. (Updated 8/5/2019) Moving Data to the Cloud with Azure Data FactoryDownload
Thank you for attending my session at the Azure Global Bootcamp on Saturday, April 27th. Attached is the document I promised. Please let me know what you think in the comments. Thanks,Simon Moving Data to the Cloud with Azure Data FactoryDownload
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
I just ran a few simple tests in Azure SQL DB to see how each would perform. I have a target table with an identity column that is the clustered primary key, and two other indexes that are the same except for the field order. (Whether having both is useful is a question for another … Continue reading When Loading Data, Should I Drop Indexes or Not?
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