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 ____”
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. :{>
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
2007-2012, 2019-
I am deeply honored to be awarded Data Platform MVP by Microsoft for 2019-2020. I was a SQL Server MVP – that’s what they used to call Data Platform MVPs back in the olde days when we used to carve our own IC’s out of wood – from 2007 to 2012. I stepped away from …
Continue reading 2007-2012, 2019-
SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!
I’m honored to deliver Intelligent Data Integration with SSIS – a full-day pre-conference session – at SQL Saturday 813 in Boston 29 Mar 2019! What is Intelligent Data Integration?SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data Integration Lifecycle Management), produced using …
Continue reading SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!
Lift and Shift SSIS to Azure
Enterprise Data & Analytics‘ data engineers are experts at lifting and shifting SSIS to Azure Data Factory SSIS Integration Runtime. Our state-of-the-art DILM Suite tools in the capable hands of our experienced data engineers combine to drastically reduce the amount of time to manually migrate and apply SSIS Catalog configuration artifacts – Literals, Catalog Environments and Catalog Environment Variables, …
Continue reading Lift and Shift SSIS to Azure
T-SQL Tuesday #111 Roundup
Thank You! First, we owe a debt of gratitude to my friend Adam Machanic (blog | @adammachanic | Data Education) for starting T-SQL Tuesday in the first place. Thank you, Adam! Next, we owe a huge shout-out to Steve Jones (blog | @way0utwest | SQL Server Central) for carrying the torch by maintaining tsqltuesday.com. Finally, thank you …
Continue reading T-SQL Tuesday #111 Roundup