Join me 15 Mar 2018 at noon ET for Introduction to Change Detection with SSIS, another free webinar sponsored by Enterprise Data & Analytics. Change detection is the central component for Incremental Load data integration patterns. In this presentation I discuss and demonstrate three change detection patterns: – No Change Detection – Brute-Force Change Detection …
Continue reading Free Webinar – Introduction to Change Detection with SSIS 15 Mar 2018
Category:Enterprise Data & Analytics
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…
A True Story of Value vs. Hourly Rate
A little over a year ago I wrote a post titled Value. If you have a few minutes Value provides good background for this post. Unlike most of my posts about business and client interactions (I have a standing rule to not blog about stuff until at least one year has passed), the stuff I share in …
Continue reading A True Story of Value vs. Hourly Rate
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
Data Wrangling Concepts: Latency and Staleness
This post was originally published at SQLBlog. Latency is the amount of time between data creation and load. Staleness is the amount of time since data in a target was refreshed. In many data integration use cases, a latency or staleness of one day, one week, or even one month is acceptable. Enterprise Data & Analytics helps enterprise data integration teams …
Continue reading Data Wrangling Concepts: Latency and Staleness
The Recording for Enterprise SSIS, Biml, and DILM is Available!
Kent and I had an awesome time delivering Enterprise SSIS, Biml, and DILM! I think it shows. You can check out the recording here (registration required). You can get the tools and utilities we demonstrated at DILM Suite – most are free and some are even open-source! You can grab the latest release of BimlExpress from Varigence! :{>
Upcoming Events Featuring the Latest Biml Products!
The latest versions of BimlExpress and BimlStudio have been released less than 24 hours – along with the debut of BimlFlex – and already there are free online events showcasing some of the products. They still have that new build smell! Enterprise SSIS, Biml, and DILM – join Kent Bradshaw and me for this fun-filled …
Continue reading Upcoming Events Featuring the Latest Biml Products!
Enterprise Data & Analytics is Sponsoring SQL Saturday Atlanta!
Enterprise Data & Analytics is proud to sponsor SQL Saturday 652 – Atlanta 15 Jul 2017! And I am honored to present Designing an SSIS Framework. Abstract Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building …
Continue reading Enterprise Data & Analytics is Sponsoring SQL Saturday Atlanta!