As I type, 2017 is drawing to a close. For many, this time of year is a time of reflection on the past year and planning for the coming year. I recently saw this Windows message in the corner of my screen and realized, “You’re right, Windows. I do need some updates.” I’m not big …
Continue reading I Need Some Updates
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.
Get The Biml Book Sample Code
You can obtain the sample code for The Biml Book at Apress. Navigate to the The Biml Book page and click the “Download source code” button. The sample code wasn’t available when the book was released. I own that and I apologize. It is available now. Happy Biml’ing! :{> Learn more: Biml Academy BimlScript.com
The Next Expert SSIS Delivery is 2.5 Days – 5-7 Mar 2018!
Yep, we’re doing it again! In cooperation with Brent Ozar Unlimited, the next delivery of Expert SSIS Training is 5-7 Mar 2018. I had a great time delivering this course with Brent in September and December 2017 and I’m excited to have the opportunity to share this material with you again! We’ve extended the course …
Continue reading The Next Expert SSIS Delivery is 2.5 Days – 5-7 Mar 2018!
Website Ch-ch-changes…
Inspired by Frank La Vigne’s (blog | @Tableteer) snappy update to the Data Driven home page, I decided to spruce up a couple / three of my websites including this one, andyleonard.blog. I added the sidebar shown on the right of the site. It contains a more-readily-available search box and links to other websites I maintain – …
Continue reading Website Ch-ch-changes…
SSIS and Visual Studio Configurations
I got a great question from a student in the December delivery of Expert SSIS. A student asked, “Why wouldn’t you use Environments in Visual Studio (Dev, Test, and Prod), and deploy accordingly the mapped project parameters and package parameters?” I’ve looked into using SQL Server Data Tools (SSDT, or Visual Studio) configurations in the …
Continue reading SSIS and Visual Studio Configurations
On Data Frameworks…
You may not realize this, but Apache Spark is a framework. Spark is cluster-computing engine that manages parallel executions extremely well. Spark enables other technologies including Java, Scala, Python, R, and graph processing. Spark stitches together previously-disparate functionality into a cohesive, syntactically-similar set of commands. Spark’s architecture is library-driven and includes the following libraries: Spark SQL …
Continue reading On Data Frameworks…
Learning Goals for 2018 – T-SQL Tuesday #97
My friend and #SqlFamily sister Mala hosts this month’s T-SQL Tuesday topic: Setting learning goals for 2018. It’s a timely topic for me as I’ve recently engaged in more formalized training. Mala’s questions: What do you want to learn? (specific skills and talents) How and when do you want to learn? (methods of learning and …
Continue reading Learning Goals for 2018 – T-SQL Tuesday #97
Achievement Unlocked: Certified in Implementing Predictive Analytics with Spark in Azure HDInsight
I learned a lot taking the course Implementing Predictive Analytics with Spark in Azure HDInsight! I’m slowly working my way through the Data Science Certification offered by Microsoft Virtual Academy along with edX. This course is not part of the official curriculum, but I’ve been wanting to learn more about Spark so I took it. Many of the courses …
Continue reading Achievement Unlocked: Certified in Implementing Predictive Analytics with Spark in Azure HDInsight
I Love Delivering Training
In December 2017, I delivered Expert SSIS training in cooperation with Brent Ozar Unlimited. I’m a Star Trek fan and I include a couple references to the series in the course. One reference is to the episode titled The City on the Edge of Forever. In my humble opinion, the plot for this episode is better …
Continue reading I Love Delivering Training
Presenting A Day of Intelligent Data Integration in NYC 18 May!
I’m honored to present A Day of Intelligent Data Integration – a SQL Saturday NYC precon – 18 May! Description What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM, produced using Biml and executed using an SSIS Framework. Attend a day …
Continue reading Presenting A Day of Intelligent Data Integration in NYC 18 May!