Browse by Tags

• Agile
• Automation
• Better at Work
• BIML
• Biml Academy
• Biml Community
• Biml Express Metadata Framework
• Biml Frameworks
• BimlExpress
• BimlHero
• BimlScript
• Business Intelligence
• Code Camp
• Community
• Consulting
• Data Flow Task
• Data Integration
• Data Philosophy
• 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!
• Geek
• Incremental
• Leadership
• Learn to Code
• Linchpin People
• Microsoft
• MicroTraining
• PASS
• PASS Community
• PASS Summit 2011
• PASS Summit 2012
• PASS Summit 2013
• PASS Summit 2015
• Personal
• Precons
• Productivity
• 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 Execution
• SSIS Frameworks
• SSIS Performance
• Training
• Transparency
• User Groups
• Values
• Virtual Chapters
• Webinars

• Presenting A Day of Intelligent Data Integration Precon at SQL Saturday Dublin!

  I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 620 – Dublin 15 Jun 2017! Description What is Intelligent Data Integration? SSIS packages developed using tried and Read More... Posted Tuesday, May 16, 2017 11:58 AM by andyleonard | 0 Comments Filed under: Automation, BIML, Biml Frameworks, Data Integration, Data Philosophy, DILM, Precons, Presentations, SQL Saturday, SSIS

• Honored to Present Use Biml as an SSIS Design Patterns Engine at SQL Saturday-NYC!

  I’m honored to present Use Biml as an SSIS Design Patterns Engine at SQL Saturday #588 in New York City 20 May 2017! I’ve been looking at the event schedule and… WOW! There are a lot of smart people presenting – plus me ! I hope to see you there. :{> Read More... Posted Friday, May 05, 2017 2:21 PM by andyleonard | 0 Comments Filed under: Automation, BIML, Biml Frameworks, BimlHero, Data Integration, Data Philosophy, DILM, ETL, Presentations, SSIS, SSIS Administration, SSIS Catalog, SSIS Execution, SSIS Frameworks

• The Recording for Designing an SSIS Framework is Now Available

  Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can now view the webinar for free (although registration is required) here . In the webinar Kent and I Read More... Posted Tuesday, May 02, 2017 5:17 PM by andyleonard | 0 Comments Filed under: Automation, Data Integration, DevOps, DILM, Presentations, Productivity, SSIS, SSIS Catalog, SSIS Frameworks

• Presenting Intelligent Data Integration Precon at SQL Saturday–Louisville!

  I am honored to present Intelligent Data Integration – a day-long precon at SQL Saturday #643 in Louisville Kentucky 4 Aug 2017! Synopsis : What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built to participate Read More... Posted Tuesday, May 02, 2017 12:30 PM by andyleonard | 0 Comments Filed under: Automation, BIML, Biml Frameworks, BimlExpress, Data Integration, DevOps, DILM, ETL, Precons, Presentations, SQL Saturday, SSIS, SSIS Frameworks

• Presenting Use Biml to Automate SSIS Design Patterns at #TriPASS 18 Apr!

  I’m honored to present Use Biml to Automate SSIS Design Patterns at the Triangle SQL Server User Group in Raleigh, NC 18 Apr 2017! …especially since I missed SQL Saturday – Raleigh last month due to illness. Abstract Perhaps you’ve heard the buzz about Read More... Posted Monday, April 17, 2017 12:52 PM by andyleonard | 0 Comments Filed under: Automation, BIML, Biml Express Metadata Framework, BimlExpress, Data Integration, ETL, Presentations, SQL Server Community

• Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Richmond!

  I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Richmond 18 Mar 2017! The Biml Express Metadata Framework is the sample code for this presentation. It’s part of the DILM Suite . I hope to see you in Richmond! :{> Read More... Posted Wednesday, February 22, 2017 6:42 AM by andyleonard | 0 Comments Filed under: Automation, BIML, Biml Express Metadata Framework, DILM, Presentations, SSIS

• Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Raleigh!

  I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Raleigh 11 Mar 2017! You can download the sample code for this presentation at the DILM Suite website here . I hope to see you in Raleigh! :{> Learn More: SSIS Design Read More... Posted Tuesday, February 21, 2017 6:22 AM by andyleonard | 0 Comments Filed under: Automation, BIML, Biml Express Metadata Framework, DILM, ETL, Presentations, SQL Saturday, SSIS

• Presenting “Using Biml as an SSIS Design Patterns Engine” at the (605) SQL Server User Group 10 Jan

  I am honored to present – albeit remotely – Using Biml as an SSIS Design Patterns Engine to the (605) SQL Server User Group in Sioux Falls, SD Tuesday 10 Jan 2017! Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, Read More... Posted Wednesday, January 04, 2017 10:14 AM by andyleonard | 0 Comments Filed under: BIML, BimlScript, Presentations, SSIS, SSIS Design Patterns

• Three Lessons Learned in 2016

  Some folks do not like to read posts of a more personal nature or posts that contain religious references. If you are one of those people, you have been forewarned. I’ve read lots of posts from people who are ready for 2016 to be over. I understand their Read More... Posted Saturday, December 31, 2016 6:17 AM by andyleonard | 2 Comments Filed under: Better at Work, Biml Community, Consulting, Ethics, Geek, Personal, Presentations, Professional Development, Transparency, Values

• 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