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
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. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
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
Free Webinar – Faster SSIS
SQL Server Integration Services (SSIS) is a powerful enterprise data integration tool that ships free with Microsoft SQL Server. Join me as I demonstrates practical SSIS performance design patterns. Register today to learn: Load BLObs faster An Incremental Load design pattern using HashBytes Using a Script Component Destination This webinar is free! Register today!
Free Webinar: Troubleshooting SSIS – 13 Mar at 12:00 PM ET
Join Microsoft Data Platform MVP, author, blogger, and Enterprise Data & Analytics Chief Data Engineer Andy Leonard for a free webinar titled Troubleshooting SSIS 13 Mar 2019 at 12:00 PM ET. Register today! Here’s a free preview!
Andy’s Database Credentials Hack
Ok, this isn’t a hack. It’s more of a tip that may help you protect data. Some of you would not have clicked a link to Andy’s Database Credentials Tip. You are welcome. LastPass I like LastPass. I pay for Premium and it’s not a bad deal, in my humble opinion. I also like Azure …
Continue reading Andy’s Database Credentials Hack