“My name is Andy and I am a huge fan of source control.” That said, I confess I have struggled with git for a couple years now. I recently had some “play time” – I love play time – and decided to play with git. In this post I will demonstrate how to create an …
Continue reading Azure DevOps, SSIS, and Git Part 0 – Getting Started
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 Design Pattern: Use Script Tasks for ETL Instrumentation
I consider scripting in SQL Server Integration Services (SSIS) my data integration “get out of jail free” card. Why? If I cannot find a way to accomplish some requirement using SSIS’s built-in objects – tasks, containers, Data Flow components, etc. – I can usually write .Net code to fulfill the requirement. As stated in the …
Continue reading SSIS Design Pattern: Use Script Tasks for ETL Instrumentation
Enterprise Data & Analytics and SentryOne
I am honored to announce Enterprise Data & Analytics is a SentryOne Consulting Partner! We began communicating regularly with SentryOne soon after they acquired the SSIS people and products from Pragmatic Works. Becoming a partner just made sense because we have been recommending Task Factory and LegiTest for years. We are honored and excited to …
Continue reading Enterprise Data & Analytics and SentryOne
Training Feedback
Here’s what students are saying about the recent Enterprise Data & Analytics free webinars and paid training: Thank you for presenting the Expert SSIS training sessions Monday and Tuesday this week. I, for one, learned something during each session. Overall, this was one of the top two or three most useful training courses I’ve attended …
Continue reading Training Feedback
UPDATE: Moving Data with Azure Data Factory – a Free Webinar
Join me Monday, 25 Mar 2019 at 12:00 PM EDT for another free webinar from Enterprise Data & Analytics titled Moving Data with Azure Data Factory! Join this webinar and learn: How to provision a Data Factory ADF constituents Building your first ADF pipeline Register today!
The Recording of Faster SSIS is Available
The recording for the free webinar titled Faster SSIS is available and may be viewed above. Thanks to everyone who attended! Regarding “Bad” BLOBTempStoragePath Settings Regarding the BLObs.dtsx demo SSIS package, Doug asked a really good question: “Does the package abort if the [BLOBTempStoragePath] folder path is invalid or does it create it for you?” …
Continue reading The Recording of Faster SSIS is Available
SSIS, Docker, and Windows Containers, Part 1 – Why?
In my first post in this series, SSIS, Docker, and Windows Containers, Part 0 – Getting Started, I covered: Installing docker Choosing a Container OS Pulling a test image Pulling a Windows Container with SQL Server installed interacting with with your instantiated container In this post I reveal my ultimate goal and then travel down …
Continue reading SSIS, Docker, and Windows Containers, Part 1 – Why?
“Andy, I Want More ____”
I am always learning. I enjoy learning and this trait led me to technology in the first place. It turns out a love of learning is all but essential for technologists. After I learn, I share what I’ve learned in blog posts, webinars, and via presentations at SQL Saturdays and events like the PASS Summit. …
Continue reading “Andy, I Want More ____”
The Recording for Troubleshooting SSIS (Part 1) is Available
A fantastic crowd attended today’s (13 Mar 2019) free webinar titled Troubleshooting SSIS. If you attended you got the full show. If not, you may view the content at SSIS Academy for a nominal fee. Enjoy this focused content to SSIS Self-Help, a service from Enterprise Data & Analytics designed to help folks quickly and …
Continue reading The Recording for Troubleshooting SSIS (Part 1) is Available
T-SQL Tuesday #112 – The Cookie Jar
This month, Shane O’Neill hosts T-SQL Tuesday. His topic is titled Dipping into the Cookie Jar and is inspired by David Goggins‘ book titled Can’t Hurt Me. Coincidence: I am currently listening to the Can’t Hurt Me audio book. I made several recent mini-road-trips to Richmond to visit my Dad (more later) – a 75-mile …
Continue reading T-SQL Tuesday #112 – The Cookie Jar