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
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
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
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