I share a lot. Because I share a lot, many people believe: I am an extrovert; and I share everything. Neither is accurate. I am an introvert with a strong desire to help others. My desire overcomes my introvert nature enough to keep me out there. Truth be told? I’d rather be spending time with …
Continue reading Slowly Coming Back, October 2020 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. :{>
SSIS Catalog Browser Live Demo
I am delivering more and more live streaming sessions. The session for today (6 Oct 2020) was all about SSIS Catalog Browser, a free utility from DILM Suite. DILM Suite hosts several utilities to help with Data Integration Lifecycle Management (DILM). Most are free and many are open source. You should check it out! Enjoy …
Continue reading SSIS Catalog Browser Live Demo
Training and Failure
The image above is a screenshot from the My Expectations slide. It’s part of my From Zero to SSIS course. You can learn more about this course (and others) at the Enterprise Data & Analytics Training page. The part in the box is important: “This is a safe place to fail.” I share that in …
Continue reading Training and Failure
Feedback From a Student
I just received this from a student who took advantage of my offer of Free Training for People Who Have Lost Their Jobs – which continues; some students in my From Zero to SSIS course delivery this week are taking advantage of this offer. How does it work? Visit the post titled Free Training for …
Continue reading Feedback From a Student
ADF and SSIS Public Training Course Schedule for 2020 and 2021
Want to learn Azure Data Factory (ADF) and SQL Server Integration Services (SSIS)? The schedule for courses is available at the Enterprise Data & Analytics Training page. Sign up for a Season Pass and Save! ADF and SSIS courses are scheduled for 2020 and 2021. Choose the Live ADF and SSIS Class Season Pass and …
Continue reading ADF and SSIS Public Training Course Schedule for 2020 and 2021
Microsoft Azure Announces Project Bicep, an ARM DSL
Managing Azure Resource Manager (ARM) templates can be challenging. The Microsoft Azure team is aware of the challenges and has released a very early-alpha-v0.1 version of a new effort named Project Bicep (ARM… bicep… get it?). From the Github page: Bicep is a Domain Specific Language (DSL) for deploying Azure resources declaratively. It aims to drastically …
Continue reading Microsoft Azure Announces Project Bicep, an ARM DSL
Learn ADF and SSIS For One Year and Save Money!
I am excited to announce Enterprise Data & Analytics has scheduled Azure Data Factory (ADF) and SQL Server Integration Services (SSIS) courses through Dec 2021! We have updated the public training schedule at the Live ADF and SSIS Class Season Pass and Training pages. In all, there are seven delivery blocks scheduled – each containing …
Continue reading Learn ADF and SSIS For One Year and Save Money!
Where’s the SSIS Dropdown Menu in Visual Studio 2019?
Just the other day, I was whining to communicating with friends on the Microsoft SSIS team about the SSIS dropdown menu in Visual Studio 2019, sharing “The SSIS dropdown menu is missing.” In Visual Studio 2017 (SQL Server Data Tools), the SSIS dropdown menu is prominently displayed alongside other top-level dropdown menu items: The SSIS …
Continue reading Where’s the SSIS Dropdown Menu in Visual Studio 2019?
How to Skip SSIS Package Validation
A new feature in version 3.9 of the Visual Studio 2019 SSIS extension is “skip package validation.” I’ve tested the functionality and it works well. Here’s how you set it up: First, install the Visual Studio 2019 SSIS version 3.9 extension. Next, open Visual Studio 2019 and click Tools > Options: Navigate to Business Intelligence …
Continue reading How to Skip SSIS Package Validation
Integration Services Extension v3.9 is Available
Integration Services Extension v3.9 is now available for Visual Studio 2019. I tested the skip-package-validation feature and I like it! Interesting (to me) is skipping deployment to Azure-SSIS for all target server version except SSIS 2017. Release Notes: Version 3.9 (Current Version): Release Date: August 24th, 2020 Build Version: 15.0.2000.128 Tested against Visual Studio 2019 16.7 …
Continue reading Integration Services Extension v3.9 is Available