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

An Alexa Skill in Javascript – Part 5

Finally, the last post in the series.  Here, we will show Alexa how to Roll Some Dice with a modifier so that we can get our skill working properly. We're going to do this in two steps: Create a function that will take the diceCount, plusMinus and modifier parameters and return the results as speech … Continue reading An Alexa Skill in Javascript – Part 5

An Alexa Skill in Javascript – Part 4

So far we've defined, gathered and installed the requisite tools in Part 1.  We've defined the Skill we're creating in Part 2.  And, we've created the Intents for our skill in Part 3. Now, we will code the Lambda function that is the brains of our skill in this entry, Part 4. What is a … Continue reading An Alexa Skill in Javascript – Part 4

An Alexa Skill in Javascript – Part 3

The Skill Model (en-US.json) Open the en-US.json file in the models folder.  Notice the areas I’ve highlighted in bold, red text.  These are things we will change. { "interactionModel": { "languageModel": { "invocationName": "greeter", "types": [ ], "intents": [ { "name": "AMAZON.CancelIntent", "samples": [ ] }, { "name": "AMAZON.HelpIntent", "samples": [ ] }, { "name": "AMAZON.StopIntent", "samples": … Continue reading An Alexa Skill in Javascript – Part 3

Unit Testing an Alexa Skill in C# – Step 3a

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