I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 705 – Richmond 23 Mar 2018! 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 …
Continue reading Presenting A Day of Intelligent Data Integration at SQL Saturday Richmond!
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.
The Biml Book is Available!
The Biml Book became available last week! I’m delayed in posting this because I was at the PASS Summit 2017 last week where I had a great time catching up with old friends, making new friends, learning new stuff, and presenting. Really exciting for Biml people, Scott Currie was on-stage to present Biml and Azure Data …
Continue reading The Biml Book is Available!
AndyLeonard.blog() is Faster!
First, thank you to everyone who visits and has visited this blog. It’s been painfully slow and I am truly sorry about that. I upgraded to a managed WordPress service at GoDaddy and things move much faster now – as you probably already realized. One nice side-effect of this change is it now takes less time …
Continue reading AndyLeonard.blog() is Faster!
The Second-Best Time
I recently returned from the PASS Summit 2017 where I had an awesome time hanging out with members of the SQL Server Community, learning, and presenting. Attending a conference inspires a bunch of ideas. If you’re like me, you might kick yourself and think, “Why didn’t I think of that sooner?!” If I had a time …
Continue reading The Second-Best Time
Lessons Learned About Community Leadership
It’s been an honor and a privilege to serve in technical community leadership at the local (Richmond Virginia) and regional level. It’s not the same as managing geeks, but there are similarities. I’ve considered serving on a national level but not taken that plunge. Over the years I’ve learned some lessons that I thought I’d …
Continue reading Lessons Learned About Community Leadership
SSIS Performance Pattern – Loading a Bajillion Records
Do you need to use SSIS to load some data from a large source? This post covers some thoughts on a couple/three patterns you may apply to help. I can hear you thinking, “Which pattern should I use, Andy?” That’s an excellent question! The answer is, “It depends.” You should test each pattern and see …
Continue reading SSIS Performance Pattern – Loading a Bajillion Records
About Me
Hi there! Welcome to my professional blog. I really appreciate you taking the time to visit. I’d like to share a couple things about myself – in case you’re interested. Why? I believe context matters. If you don’t agree, feel free to skip on past this post and enjoy the ten years of content stored …
Continue reading About Me
Announcing Biml Academy v2.0
Update: See this post at Biml Academy for an opportunity to sign up for 50% off! I am pleased to announce the relaunch of Biml Academy! The site currently hosts free training from the very first Biml Academy week – way back in the Spring of 2016. I delivered that training while on the road. …
Continue reading Announcing Biml Academy v2.0
One Solution to Presentation Levels
I’ve made no secret of my personal disdain for Presentation Levels. My non-appreciation for presentation levels is largely driven by presentation evaluation complaints received over the years. These complaints mostly read the same (paraphrased): “The presentation was advertised as Level 200, but I felt it was more of a Level 100 (or 300, or whatever) …
Continue reading One Solution to Presentation Levels
My New Title is Chief Data Engineer
My new job title at Enterprise Data & Analytics is Chief Data Engineer. “What’s a Data Engineer, Andy?” I’m glad you asked! Data Science is a broad term applied to analytics derived from the statistical analysis of data. “So, what do data scientists actually do?” That’s a fantastic question: Data scientists experiment. they use tools like …
Continue reading My New Title is Chief Data Engineer