If you haven't done so already, check out Step 1 to define your Alexa Skill. After defining the Alexa Skill in Step 1, you are ready to set up Visual Studio in Step 2. AWS Account and AWS Toolkit Extension Before you can set up an Alexa project, you need to create an AWS Lambda … Continue reading Creating an Alexa Skill in C# – Step 2
Author: Simon Kingaby
Creating an Alexa Skill in C# – Step 1
Recently, I decided to make an Alexa skill that I could play on my boss's Alexa. At first, I was doing it as a gag, but I figured that wouldn't work as he has to actively install my skill onto his Alexa. Now it reads some stats from one of our Azure databases and publishes … Continue reading Creating an Alexa Skill in C# – Step 1
Connecting to IBM DB2 zOS from Azure Data Factory v2
Connecting to IBM DB2 zOS from Azure Data Factory v1 was a matter of setting up the Azure Data Gateway on an on-prem server that had the IBM DB2 Client installed; creating an ODBC connection to DB2 (I called it DB2Test). Then, in the Data Factory v1 Copy Wizard, Select the ODBC source, pick the … Continue reading Connecting to IBM DB2 zOS from Azure Data Factory v2
SQL Saturday Charlotte 2017
I am excited to announce I am finally ready to present my advanced ETL Framework with Biml seminar at SQL Saturday Charlotte on Oct 14. And I have a 10AM slot!!! Wooo! Implementing a SSIS Framework and enforcing SSIS Patterns (with Biml). (Using Biml to Automate the Implementation of a SSIS Framework) Let's use Biml … Continue reading SQL Saturday Charlotte 2017
BMI KeyNotes – Toastmasters Speech on Biml
As practice for delivering a 50-minute seminar to my fellow ETL Developers at BMI, I presented Speech 5 from the Toastmasters Technical Presentations manual. It was a whopping 12-15 minute speech and I didn't go over time!!! Yay!!! (I normally blow through the red card and end up a minute or two over my … Continue reading BMI KeyNotes – Toastmasters Speech on Biml
SQL Saturday Atlanta!
I am excited to announce that I will be giving my BIML seminar in Atlanta in July!!! Here's the abstract for my session: How to move a ton of data from the Mainframe to the Cloud (with Biml). So, you need to move data from 75 tables on the mainframe to new tables in SQL … Continue reading SQL Saturday Atlanta!
SQL Saturday!!!
Yay!!! I'll be speaking about Biml at SQL Saturday in Chattanooga in June! I'm very excited. In typical fashion, I will probably cram too much into the hour, but I'll try not to. Here's the abstract for my session. Using Biml to Automate the Generation of SSIS Packages So, you need to move data from … Continue reading SQL Saturday!!!
Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator
Now that we can generate simple empty packages, the next step is to add connection managers to the project and package. After that, we will add a DataFlow. This article will focus on the Connections though, and we will start with a pair of standard OleDb Connections. Recall the metadata tables from the last article: … Continue reading Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator
Biml Tutorial 2 – Creating a Simple Package Generator
So I spent yesterday morning entering the metadata to describe some 70 or so packages that are all part of a big data load that moves data off the mainframe (DB2) into SQL Azure. Occasionally, I would build the packages with BIML Express to ensure I hadn't introduced bad metadata. Today, I tweaked the BIML to allow for … Continue reading Biml Tutorial 2 – Creating a Simple Package Generator
A New Adventure…
I've added a few new acronyms to my life this past week: BMI, BNA, and TN. I've accepted a position at Broadcast Music Inc. (BMI), which is in Nashville (BNA) Tennessee (TN). This will require a move from Charlotte to Nashville. Something we are going to have to work on over the next few weeks. … Continue reading A New Adventure…
One Man went to Mow... 