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
In Step 3, we created the Lambda function that will provide the functionality of the Alexa Skill we defined in Step 1, we wired everything up and then we tested our Skill. So far so good. However, that's an awful long way round to test the Skill Request and Response. It would be nice if … Continue reading Unit Testing an Alexa Skill in C# – Step 3a