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
Tag:Azure
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
Getting Started with Azure Automation
Azure Automation has been around for a few years now. I just got started because my brother and friend, Aaron Nelson (@SQLvariant), shared some automation he’s been working on. Once I got my head around the piece I’m about to share with you, Azure Automation started to make sense to me. Set Up an Azure …
Continue reading Getting Started with Azure Automation
One Way to Create an Azure Integration Runtime
Many Azure Data Factory developers recommend creating an Azure Integration Runtime for use with Mapping Data Flows. Why? One reason is you cannot configure all the options in the default AutoResolveIntegrationRuntime supplied when an Azure Data Factory instance is provisioned. At the time of this writing, it’s not obvious how one creates an Azure Integration …
Continue reading One Way to Create an Azure Integration Runtime
AndyStream for 17 Nov 2021
Frank and I are on Day 15 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build – and stick to – atomic habits and systems of execution. This morning I popped on for a few minutes to share information about upcoming live …
Continue reading AndyStream for 17 Nov 2021
Azure DevOps, Git, and SSIS
After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS
DILM Suite + Azure Data Factory Integration Runtime
DILM Suite was designed to support enterprise data engineering / data integration with SSIS. But the solutions, utilities, and tools work well with Azure Data Factory Integration Runtime (ADF IR, or “SSIS in the cloud”). As I mentioned in my post titled The Cloud Costs Money, leaving ADF Integration Runtime running can get pricey – …
Continue reading DILM Suite + Azure Data Factory Integration Runtime
Updates to Three DILM Suite Applications
It’s been a busy couple weeks here at Enterprise Data & Analytics in Farmville. I just published updates to not one, not two, but three – yes, three! – applications that are part of the Data Integration Lifecycle Management Suite, or DILM Suite. SSIS Framework Community Edition To prepare for Thursday’s (12 Jul 2018) webinar titled …
Continue reading Updates to Three DILM Suite Applications
Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun
Andy’s Summer-o’-ADF continues with another free (yes, FREE) webinar! Abstract Join me as I begin to explore a brand new topic: Azure Data Factory Design Patterns. This first webinar in the series is titled The Azure Data Factory Controller Design Pattern. In this demo-tastic session I show how to apply the pattern described in …
Continue reading Free Webinar – The Azure Data Factory Controller Design Pattern – 28 Jun