I will be speaking at SQL Saturday St. Louis on Saturday, February 8th at 8:00 am and 10:20 am. The topics are: 8:00 am Moving Data to the Cloud (with Azure Data Factory) You need to move data. A lot of data. To the cloud. You’ve got data in a variety of on- and off-site … Continue reading SQL Saturday St. Louis – February 2020
Azure
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
Music City Data – Nashville
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 I've also added a login so you can see the objects I worked on in the seminar.User Id: student@omwtm.comPassword: JB_s7K%(et;Y Let me know if you have any questions or comments.
SQL Saturday 2019 – Louisville
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 I've also added a login so you can see the objects I worked on in the seminar.User Id: student@omwtm.comPassword: JB_s7K%(et;Y Let me know if you have any questions or comments.
SQL Saturday 2019 – Chattanooga
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
Azure Global Bootcamp
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
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
When Loading Data, Should I Drop Indexes or Not?
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?
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
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
One Man went to Mow... 