Browse by Tags

• Agile
• Automation
• BIML
• Biml Academy
• BimlHero
• BimlScript
• Business Intelligence
• Code Camp
• Community
• Data Flow Task
• Data Integration
• Data Warehouse
• Data Warehousing
• database design
• Database Developer
• Database Testing
• DBA
• Denali
• Deployment
• Design Pattern
• Developer Community
• DevOps
• DILM
• EIM
• Elegant Design
• EMPs (Expensive Management Practices)
• Ethics
• ETL
• ETL Instrumentation
• Executing SSIS
• From Zero to SSIS!
• Incremental
• Leadership
• Learn to Code
• Linchpin People
• Microsoft
• MicroTraining
• PASS
• PASS Community
• PASS Summit 2011
• PASS Summit 2012
• PASS Summit 2013
• PASS Summit 2015
• Precons
• Professional Development
• SQL Azure
• SQL Saturday
• SQL Server
• SQL Server 2012
• SQL Server 2014
• SQL Server Community
• SQLBits 9
• SQLConnections
• SQLLunch
• SQLRally
• SSIS
• SSIS 2012
• SSIS 2014
• SSIS 2016
• SSIS Administration
• SSIS Catalog
• SSIS Catalog Compare
• SSIS Design Patterns
• SSIS Frameworks
• SSIS Performance
• Training
• Transparency
• User Groups
• Virtual Chapters
• Webinars

• I’m Presenting at SQL Saturday Charlotte (#560) Next Saturday!

  I’m honored and all giggly with anticipation about presenting at SQL Saturday 560 in Charlotte next Saturday, 17 Sep 2016! I’m presenting Biml and SSIS Frameworks , and I hope to see many of you there. For the SSIS Frameworks part of my presentation, Read More... Posted Saturday, September 10, 2016 11:33 AM by andyleonard | 0 Comments Filed under: BIML, BimlScript, Presentations, SSIS, SSIS Administration, SSIS Catalog, SSIS Frameworks

• The Recording for Biml Academy 2–Lesson 5 is Now Available!

  The recording for Biml Academy 2 - Lesson 5 - Importing Data with Biml by Cathrine Wilhelmsen [ Blog | @cathrinew ] is now available! Cathrine did an outstanding job walking through several methods for importing database schemas using Biml. It’s worth Read More... Posted Monday, August 15, 2016 5:15 PM by andyleonard | 0 Comments Filed under: BIML, Biml Academy, Presentations

• Free Webinar 28 Mar at 1:00 PM EDT - DILM with Catalog Compare

  Join me 28 Mar 2016 at 1:00 PM EDT for DILM with Catalog Compare - another (FREE!) webinar from Enterprise Data & Analytics ! DILM (Data Integration Lifecycle Management) is how data integration is done in the modern DevOps enterprise. Join Andy Leonard, Read More... Posted Tuesday, March 08, 2016 5:45 AM by andyleonard | 0 Comments Filed under: DILM, Presentations, SSIS Administration, SSIS Catalog, SSIS Catalog Compare

• Recording Available for “Biml 201: Batched Incremental Load in the SSIS Framework”

  You can view the recording for Biml 201: Batched Incremental Load in the SSIS Framework - a free webinar from Enterprise Data & Analytics (registration required). The source code is available here . Enjoy! :{> Next webinar: DILM with Catalog Compare Read More... Posted Monday, March 07, 2016 3:44 PM by andyleonard | 0 Comments Filed under: BIML, BimlScript, Business Intelligence, Data Integration, DILM, Executing SSIS, Presentations, SSIS Frameworks

• Easy SSIS Migration with SSIS Catalog Compare Recording is Available!

  The recording for the webinar titled Easy SSIS Migration with SSIS Catalog Compare is now available! Enjoy! :{> Read More... Posted Monday, February 15, 2016 4:43 PM by andyleonard | 0 Comments Filed under: Data Integration, DILM, ETL, Presentations, SSIS, SSIS Catalog Compare, Webinars

• More Training from Andy Leonard!

  First, thanks to everyone who has attended one of my free webinars! I enjoy delivering training and hope that it shows. Where can you learn about upcoming training from me? At the Enterprise Data & Analytics   Training page , of course. Upcoming Read More... Posted Tuesday, January 19, 2016 1:52 PM by andyleonard | 0 Comments Filed under: Data Integration, DevOps, DILM, ETL, Presentations, SSIS, SSIS Design Patterns, Training, Webinars

• Introduction to SSIS Frameworks Recording Now Available!

  The recording for the webinar " Introduction to SSIS Frameworks " is now available! (Registration required) :{> Read More... Posted Sunday, January 10, 2016 9:52 PM by andyleonard | 3 Comments Filed under: Presentations, SSIS, SSIS Frameworks

• 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: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Read More... Posted Monday, December 21, 2015 12:39 PM by andyleonard | 2 Comments Filed under: Automation, BIML, BimlScript, Presentations, SSIS

• 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 Read More... Posted Wednesday, November 25, 2015 10:10 AM by andyleonard | 0 Comments Filed under: Learn to Code, Presentations, SSIS

• 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 Read More... Posted Saturday, November 21, 2015 8:00 AM by andyleonard | 1 Comments Filed under: PASS Summit 2015, Presentations

• Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia

  I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration ! This Read More... Posted Thursday, November 12, 2015 2:29 PM by andyleonard | 0 Comments Filed under: Agile, Automation, BIML, BimlHero, BimlScript, Business Intelligence, Community, Data Integration, Data Warehouse, Design Pattern, DevOps, DILM, Elegant Design, ETL, ETL Instrumentation, Executing SSIS, Precons, Presentations, SQL Saturday, SQL Server, SQL Server Community, SSIS, SSIS 2012, SSIS 2014, SSIS 2016, SSIS Administration, SSIS Catalog, SSIS Design Patterns, SSIS Frameworks, SSIS Performance

• Presenting at SQL Saturday 431–Spartanburg 26 Sep!

  I am honored to present two sessions at SQL Saturday #431 in Spartanburg, SC on 26 Sep 2015 ! I will be delivering: Designing an SSIS Framework in 2015 Using Biml as an SSIS Design Patterns Engine SQL Saturday #431 also features two stellar precons: Transforming Read More... Posted Saturday, September 12, 2015 9:45 AM by andyleonard | 0 Comments Filed under: BIML, BimlScript, Data Integration, Developer Community, Presentations, SQL Saturday, SQL Server Community

• Presenting SSIS 2014 Data Flow Tuning Tips and Tricks at Triad PASS BI 25 Aug 2015!

  I am honored to present SSIS 2014 Data Flow Tuning Tips and Tricks to the Triad PASS BI chapter in Winston-Salem 25 Aug 2015. Do you want SSIS to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, Read More... Posted Monday, August 24, 2015 9:33 PM by andyleonard | 0 Comments Filed under: Data Integration, Developer Community, ETL, ETL Instrumentation, Presentations, SSIS, SSIS Performance

• Presenting Using Biml as an SSIS Design Patterns Engine at Hampton Roads .Net UG 11 Aug

  I am honored to present Using Biml as an SSIS Design Patterns Engine at the Hampton Roads .Net Users Group ( @HRNUG ) 11 Aug 2015! Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Read More... Posted Wednesday, July 29, 2015 8:00 AM by andyleonard | 0 Comments Filed under: BIML, BimlScript, Presentations, SSIS

• Presenting SSIS Data Flow Performance Patterns at Charlotte BI Group 7 Jul!

  I’m honored to present “SSIS Data Flow Performance Patterns” at the Charlotte BI Group 7 Jul 2015! In this session, I discuss Data Flow Task internals and patterns that improve SSIS 2014 Data Flow performance in your data integration enterprise: Incremental Read More... Posted Wednesday, June 24, 2015 5:44 PM by andyleonard | 0 Comments Filed under: Business Intelligence, Data Flow Task, Presentations, SSIS, SSIS 2014, SSIS Design Patterns