A long time ago in a galaxy far, far away… I wrote about ETL Instrumentation. Ok, it wasn’t that long ago, and it wasn’t far away. But things have changed some since I wrote that series, and I would like to spend some time updating the material. I’m typing this post at the end of …
Continue reading ETL Instrumentation in 2016
Author:Andy Leonard
SSIS Design Patterns and BIML: A Day of Intelligent Data Integration
I’m honored to deliver a brand new precon (the PowerPoint slides still have that new slide smell) at SQL Saturday #477 – Atlanta – BI Edition! The precon is titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration. Abstract Join Andy Leonard, founder of Enterprise Data & Analytics, SSIS coach and trainer, …
Continue reading SSIS Design Patterns and BIML: A Day of Intelligent Data Integration
Presenting “Use Biml to Automate SSIS Design Patterns” at SQL Saturday-Nashville!
I’m honored to present “Use Biml to Automate SSIS Design Patterns” at SQL Saturday – Nashville 16 Jan 2016! Abstract: [sql] Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one …
Continue reading Presenting “Use Biml to Automate SSIS Design Patterns” at SQL Saturday-Nashville!
My New Gig: Enterprise Data & Analytics!
I’m excited to announce my next venture: Enterprise Data & Analytics! My role is still Data Philosopher. My job is to help clients realize the potential of their enterprise data. “How will you do that, Andy?” I’m glad you asked. EnterpriseDNA delivers consulting, analysis, and development to support: Business Intelligence and Analytics Data Strategy Coaching …
Continue reading My New Gig: Enterprise Data & Analytics!
Announcing SSIS Catalog Reports v0.1
I’ve released a (very early) version of SSIS Catalog Reports – v0.1 – on GitHub. You can access the project here. My main goal is to provide some visibility into the SSIS Catalog without the need for SQL Server Management Studio. “Why, Andy?” I’m glad you asked. In some enterprises, there may be: Operations people …
Continue reading Announcing SSIS Catalog Reports v0.1
Leaving Linchpin People
I’m sad and excited to announce I am no longer with Linchpin People. I’m sad because I will miss working with and leading the awesome team at Linchpin People. I’m excited to return to independent consulting as Andy Leonard Consulting! Update: My new venture is Enterprise Data & Analytics! :{>
Presenting at BIG PASS 10 Dec 2015!
I am honored to announce I will be presenting (remotely) “I See a Control Flow Tab. Now What?” at BIG PASS in Lake Forest, California 10 Dec 2015 at 6:30 PM PT! This demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the …
Continue reading Presenting at BIG PASS 10 Dec 2015!
SSIS Catalog Compare 3-Minute Drill
The actual time is about 3:15… In a new video, I demonstrate how to use SSIS Catalog Compare to deploy an SSIS Project and all configurations metadata from one SSIS Catalog to another. I call it the 3-Minute Drill. Enjoy! :{> Learn more: Product Catalog Compare 0.5 Browsing the Catalog Catalog Compare 0.5 Comparing Catalogs …
Continue reading SSIS Catalog Compare 3-Minute Drill
Announcing Three Free Biml and SSIS Webinars
Thanks to everyone who attended the Biml 101 webinar! The recording and demo files for Biml 101 are available here. I’ve scheduled three additional webinars in the series: 1:00 PM ET 16 Dec 2015 – Biml 102: Using Biml as an SSIS Design Patterns Engine 1:00 PM ET 6 Jan 2016 – Introduction to SSIS …
Continue reading Announcing Three Free Biml and SSIS Webinars
PASS Summit 2015 Feedback
We are part of an awesome community. The SQL Server Community or SQL Family, as many call it, is astounding. Our annual Big family reunion is the PASS Summit. I received feedback from attendee evaluations the other day and I would like to share some of the feedback for one reason: Many people spoke at …
Continue reading PASS Summit 2015 Feedback
