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
SQL Server
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?
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
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!!!