Category:Uncategorized

An attendee at today’s Biml 103 webinar (Automating SSIS Design Patterns with Biml – this link takes you to register to view the recording) asked a very good question in a follow-up email: “Where can I learn enough C# to use Biml?” The answer is the C# Primer at BimlScript.com! Read, then test your knowledge! …
Continue reading “Where Can I Learn Enough C# to Use Biml?”

The recording for the webinar "Introduction to SSIS Frameworks" is now available! (Registration required) :{>

You can now view the recording from the SSIS Catalog Compare and DILM presentation here. I’m trying something new here, so please bear with me. This link takes you to a registration page. After you register, you can view the recording. Enjoy! :{>

During a delivery of Advanced SSIS Training (by Tim Mitchell and Andy Leonard), Michael Smith suggested an idea for a site where SSIS performance benchmarks could be created and recorded. Thus, SSISPerformance.com was born. I was so struck by the idea; I purchased the domain while Tim was delivering a couple modules on Advanced SSIS! …
Continue reading SSISPerformance.com

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

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

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!

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!

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

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!  :{>