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
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. :{>
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
31 Aug 2022 Blog Stuff
Every now and then I like to see how this blog is performing. I’ve published 1,615 posts. Many (999, if memory serves) were originally published on a different site before I left that site and started blogging here at andyleonard.blog. The 19 drafts are in various stages of incompleteness. I keep them around because I …
Continue reading 31 Aug 2022 Blog Stuff
Three New Azure Training Offerings
Enterprise Data & Analytics Training announces three options for learning Azure (from me!). Start today for free with our 7-day free trial! Azure QuickStart Monthly – Subscribe monthly for one low monthly cost. Azure QuickStart Yearly – Subscribe yearly and save. Get two months free! Azure QuickStart Premium – A yearly subscription that includes access to recordings of …
Continue reading Three New Azure Training Offerings
Getting Started with Azure Automation – Part 1 Video
A little ago, I blogged about Getting Started with Azure Automation. I’ve created this video for the first part of that post. To see the remainder of this video – plus recordings of all my training – sign up for Enterprise Data & Analytics Premium Level today! Enjoy. Learn More I’m presenting Master the Fundamentals of …
Continue reading Getting Started with Azure Automation – Part 1 Video
Video Training for One Way to Add an Existing Data Factory to Github Series
I created a new course as part of Premium Level at Enterprise Data & Analytics. Managing Code in Azure Data Factory is the latest addition to the growing collection of Azure content: Read the blog series: One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data …
Continue reading Video Training for One Way to Add an Existing Data Factory to Github Series
One Way to Add an Existing Data Factory to Github, Part 3
This is part of a series of posts. This post focuses on using Azure Data Factory with a GitHub repository. One Way to Add an Existing Data Factory to Github, Part 1 One Way to Add an Existing Data Factory to Github, Part 2 One Way to Add an Existing Data Factory to Github, Part …
Continue reading One Way to Add an Existing Data Factory to Github, Part 3