I am honored to present A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Data Analytics Edition (#1042) 24 Feb 2023! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: Editing ADF pipeline JSON Version control integration Copying data …
Continue reading Presenting A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Analytics Edition
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>
Azure-SSIS Express Custom Setup License Key Textbox Update
Back in June 2022, I was honored to deliver a webinar along with the good people on the SolarWinds Task Factory team. During that presentation, I noticed (and I may have even commented on) the License key textbox not being masked when adding Task Factory to an Azure-SSIS integration runtime. I sent a note to the …
Continue reading Azure-SSIS Express Custom Setup License Key Textbox Update
Join Me at SQLBits 2023!
I am honored to deliver a Training Day session at SQLBits 2023: A Day of Azure Data Factory is a full-day Training Day session scheduled for Tuesday, 14 Mar 2023. In this session I cover version control integration, copying data, using parameters and metadata, design patterns (of course!), and more! I hope to see you …
Continue reading Join Me at SQLBits 2023!
Install and Configure SQL Server 2022 Developer Edition
This post is for people interested in setting up an instance of SQL Server 2022 Developer Edition for personal use. I caution those interested in configuring an instance of SQL Server 2022 for production purposes: You should not use Developer Edition because it’s not for production workloads by design and according to the EULA. In …
Continue reading Install and Configure SQL Server 2022 Developer Edition
Download SQL Server 2022 Developer Edition
This post is for people interested in setting up an instance of SQL Server 2022 Developer Edition for personal use. If you are interested in configuring an instance of SQL Server 2022 for production purposes, you should not use Developer Edition – it’s not for production workloads by design and according to the EULA. SQL …
Continue reading Download SQL Server 2022 Developer Edition
One Way to Install SQL Server 2022 Developer Edition
In this series, I walk through one way to install and configure SQL Server 2022 Developer Edition. This series is not intended as guidance for production environments. This series is simply one way I install and configure SQL Server 2022 for my test and exploration environment. Download SQL Server 2022 Developer Edition Install and Configure …
Continue reading One Way to Install SQL Server 2022 Developer Edition
T-SQL Tuesday #156 – On Production Code
This month’s T-SQL Tuesday is hosted by Tom Zika. Tom’s topic is a good one: “Which quality makes code production grade?” I can hear data minds thinking, “It depends.” I prefer all code to be idempotent, a $3 word that means whenever the code is executed, the post-execution state is predictable (even if the initial …
Continue reading T-SQL Tuesday #156 – On Production Code
On Experience
The following images (from FreeCell) illustrate a couple points about: Net Promoter Score (NPS) Experience Image 1 For the purposes of this post, please imagine the FreeCell win percentage is our Net Promoter Score (NPS). Image 1 displays a perfect NPS. But note something the NPS does not include – the number of games played (and …
Continue reading On Experience
Failed to Update Server Errors When Configuring Networking
Recently, I attempted to update the Networking for an Azure SQL Server I use when delivering training. Specifically, I was attempting to set “Public network access” to “Selected networks,” add my client IP, and check the “Allow Azure services and resources to access this server” checkbox – found on the Networking blade for my new …
Continue reading Failed to Update Server Errors When Configuring Networking
Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022
Update 19 Sep 2022: I communicated with the Microsoft SSIS Team. They shared they are targeting preview of VS2022 Integration Services Extension for the end of CY22. Important Note: I have not yet tested this version of the Integrated Services Extension in Visual Studio 2022. On 28 Jul 2021, the Microsoft SSIS Team released an …
Continue reading Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022