Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

Browse by Tags

All Tags » Presentations   (RSS)

• BIML
• BimlScript
• Business Intelligence
• Code Camp
• Community
• Data Flow Task
• Data Warehousing
• database design
• Database Developer
• Database Testing
• DBA
• Denali
• Deployment
• Design Pattern
• Developer Community
• EIM
• Elegant Design
• EMPs (Expensive Management Practices)
• ETL
• ETL Instrumentation
• From Zero to SSIS!
• Incremental
• Linchpin People
• Microsoft
• MicroTraining
• PASS
• PASS Community
• PASS Summit 2011
• PASS Summit 2012
• PASS Summit 2013
• 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 Catalog
• SSIS Frameworks
• SSIS Performance
• Training
• Transparency
• User Groups
• Virtual Chapters

• Presenting Enterprise Information Management in SQL 2012 and SQL 2014 in Reston 16 May!

  I am honored to participate in the Reston SQL Server 2014 Launch Update event – a half-day event held 16 May 2014 at the Microsoft Reston Office. You can learn more and register here . Art Rask will kick-off the event with an overview of new features Read More... Posted Thursday, April 17, 2014 2:06 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, ETL, Microsoft, Presentations, SQL Server 2012, SSIS 2012, SSIS 2014, SQL Server 2014, EIM

• Presenting SSIS 2014 Data Flow Tuning Tips and Tricks in Boston 14 May!

  I am honored to announce I will be presenting SSIS 2014 Data Flow Tuning Tips and Tricks at the New England SQL Server User Group Wednesday, 14 May 2014! SSIS 2014 Data Flow Tuning Tips and Tricks Want to go fast? This session is for you! Attend and learn Read More... Posted Friday, April 04, 2014 1:16 PM by andyleonard | 0 Comments Filed under: Presentations, Data Flow Task, SSIS 2014, SQL Server 2014, SSIS Performance

• Presenting Using Biml as an SSIS Design Patterns Engine at NoVaSQL in Washington DC Monday!

  I am honored to present Using Biml as an SSIS Design Patterns Engine Monday 24 Mar 2014 at the Northern Virginia SQL Server User Group ( NoVaSQL )! I hope to see you there. Details… :{> Read More... Posted Wednesday, March 19, 2014 12:57 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Developer Community, Presentations, Community, SSIS 2012, BIML, BimlScript

• Presenting Using BIML as an SSIS Design Patterns Engine at SQL Saturday 241–Cleveland!

  I am excited to be presenting Using BIML as an SSIS Design Patterns Engine at SQL Saturday #241 – Cleveland on Saturday 8 Feb 2014! If you’re going to be in the Cleveland area, check out these smart presenters (plus me!) and consider attending! Register Read More... Posted Monday, January 27, 2014 11:20 AM by andyleonard | 0 Comments Filed under: Design Pattern, SQL Saturday, Presentations, BIML

• Presenting Using Biml as a Design Patterns Engine to Midlands PASS 9 Jan 2014!

  I am honored to present Using Biml as a Design Patterns Engine to the Midlands PASS Chapter Thursday 9 Jan 2014! Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, Read More... Posted Sunday, December 29, 2013 2:55 PM by andyleonard | 0 Comments Filed under: Developer Community, Presentations, SQL Server Community, Community, SQL Server 2012, BIML, BimlScript

• Presenting Designing an SSIS Framework at the PASS Summit 2013

  I am honored to deliver a presentation entitled Designing an SSIS Framework at the PASS Summit 213 in Charlotte Thursday 17 Oct 2013 at 3:00 PM EDT. A couple years ago I released a public SSIS Framework. You can read about the release here and download Read More... Posted Thursday, October 17, 2013 2:46 PM by andyleonard | 0 Comments Filed under: Presentations, SSIS Frameworks, PASS Summit 2013

• Presenting A Day of SSIS 2012 (Precon) at SQL Saturday Dallas

  I am honored to present a day-long preconference before SQL Saturday 255 (Dallas) entitled A Day of SSIS 2012 . Please register here . I’m excited to visit the Dallas area! Here’s some information about the precon – I hope to see you there! Training Description Read More... Posted Wednesday, August 28, 2013 8:30 AM by andyleonard | 1 Comments Filed under: Developer Community, SQL Saturday, Presentations, SSIS Frameworks, Community, SSIS 2012, SSIS Catalog

• Presenting SSIS Design Patterns PostCon at SQLConnections!

  I am honored to be delivering a day-long post-conference workshop at SQLConnections, focusing on SSIS Design Patterns . I’m also delivering sessions on: Using Biml as an SSIS Design Patterns Engine Hacking the SSIS 2012 Catalog “I See a Control Flow. Read More... Posted Tuesday, August 27, 2013 10:09 PM by andyleonard | 0 Comments Filed under: Developer Community, Presentations, SQLConnections, BIML

• This Isn’t Hard: Allow Spouses to Attend Conferences

  There was a bit of a hubbub at Tech Ed 2013 North America . It began with generalized disorganization, escalated when site security escorted Greg Young’s ( blog | @gregyoung ) wife from the building, and ended with him cancelling his presentations at Read More... Posted Saturday, July 27, 2013 12:20 PM by andyleonard | 13 Comments Filed under: Developer Community, Presentations, Community

• Security and SSIS Recording Now Available!

  Brian Kelley ( blog | @kbriankelley ) delivered an awesome and at times scary - no offense, Grant Fritchey ( blog | @GFritchey ) - presentation today on Security and SSIS. The recording is now available here . Enjoy! :{> Read More... Posted Wednesday, May 29, 2013 3:15 PM by andyleonard | 0 Comments Filed under: SSIS, Presentations, Linchpin People

• Announcing the 2013 Biml Workshop 15 Oct 2013 in Charlotte NC!

  When : October 15, 2013 8:45 am - 4:45 pm Charlotte, NC Where : Wake Forest University Charlotte Center 200 North College Street Charlotte, NC 28202 What : Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual Read More... Posted Saturday, May 18, 2013 1:00 AM by andyleonard | 0 Comments Filed under: SSIS, Presentations, SSIS Frameworks, SSIS 2012, BIML, SSIS Catalog, BimlScript

• Little Data Remains Important in Healthcare IT

  In his article Healthcare's Big Problem With Little Data , author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization Read More... Posted Tuesday, April 30, 2013 11:31 AM by andyleonard | 2 Comments Filed under: SSIS, ETL, ETL Instrumentation, Elegant Design, Presentations, Data Warehousing, SSIS 2012

• Scripting and SSIS - Free Webinar!

  Join SQL Server MVP Tim Mitchell ( blog | @Tim_Mitchell ) and I as we demonstrate and discuss the many uses of scripting in SQL Server 2012 Integration Services 8 May 2013 at 11:00 AM EDT! In this demo-packed session, two co-authors of the book SSIS Design Read More... Posted Wednesday, April 17, 2013 12:51 PM by andyleonard | 2 Comments Filed under: Presentations, SSIS 2012

• Medical Data Integration with SSIS 2012, Part 2 - 1 May 2013 11:00 AM EDT

  Kent Bradshaw and I are pleased to announce another free webinar: Medical Data Integration with SSIS 2012, Part 2 - Providers and Drugs. Register today! The recording of the first part of this series is available here . :{> Read More... Posted Tuesday, April 16, 2013 11:27 AM by andyleonard | 0 Comments Filed under: Presentations, SSIS 2012, Linchpin People

• Presenting at SQL Saturday 189–Costa Rica!

  I am honored to present Creating a Custom SSIS Task this Saturday – 13 Apr 2013 – at SQL Saturday 189 – Costa Rica ! Espero que se unan a mí! :{> Read More... Posted Tuesday, April 09, 2013 12:00 PM by andyleonard | 0 Comments Filed under: Presentations, SSIS 2012