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!

Browse by Tags

All Tags » Design Pattern   (RSS)

• ALM
• BIML
• BimlScript
• Books
• Business Intelligence
• Code Camp
• Components
• Data Warehouse
• Data Warehousing
• database design
• Database Developer
• Deployment
• Developer Community
• Elegant Design
• ETL
• ETL Instrumentation
• Expression Language
• Incremental
• measurement
• MicroTraining
• PASS
• PASS Summit 2010
• PASS Summit 2011
• PASS Summit 2012
• Presentations
• SQL Azure
• SQL Saturday
• SQL Server
• SQL Server 2008
• SQL Server 2012
• SQL Server Community
• SQLLunch
• SSIS
• SSIS 2012
• SSIS Frameworks
• SSIS Snack
• User Groups
• Writing

• BimlScript: Incremental Load Design Pattern

  Are you using Biml yet? Why not?! Business Intelligence Markup Language (Biml) speeds and simplifies SSIS development and improves code quality. There's a good reason that sounds like a win/win - it is a win/win! Best of all, BidsHelper supports Biml Read More... Posted Wednesday, February 06, 2013 8:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, Incremental, SSIS 2012, BIML, BimlScript

• Presenting Loading Data Warehouse Partitions with SSIS 2012 at SQL Saturday DC!

  Join Darryll Petrancuri and I as we present Loading Data Warehouse Partitions with SSIS 2012 Saturday 8 Dec 2012 at SQL Saturday 173 in DC ! SQL Server 2012 table partitions offer powerful Big Data solutions to the Data Warehouse ETL Developer. In this Read More... Posted Monday, November 19, 2012 2:37 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Data Warehousing, SSIS 2012

• SSIS Design Pattern: Producing a Footer Row

  The following is an excerpt from SSIS Design Patterns (now available in the UK!) Chapter 7, Flat File Source Patterns. The only planned appearance of all five authors presenting on SSIS Design Patterns is the SSIS Design Patterns day-long pre-conference Read More... Posted Tuesday, October 09, 2012 8:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Books, SSIS 2012

• Join the Authors of SSIS Design Patterns at the PASS Summit 2012!

  My fellow authors and I will be presenting a day-long pre-conference session titled SSIS Design Patterns at the PASS Summit 2012 in Seattle Monday 5 Nov 2012! Register to learn patterns for: Package execution Package logging Loading flat file sources Read More... Posted Wednesday, September 19, 2012 6:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Presentations, PASS Summit 2011, SSIS 2012, PASS Summit 2012

• Book Review: SSIS Design Patterns

  Samuel Vanga ( Blog | @SamuelVanga ) has posted a review of our new book SSIS Design Patterns at his blog . Several of Sam’s statements struck me, but none more than this: Within a few hours of reading SQL Server 2012 Integration Services Design Patterns Read More... Posted Monday, September 17, 2012 10:05 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, SSIS 2012

• Learn SSIS from the Authors of SSIS Design Patterns at the PASS Summit 2012!

  Jessica Moss ( blog | @jessicammoss ), Michelle Ufford ( blog | @sqlfool ), Tim Mitchell ( blog | @tim_mitchell ), Matt Masson ( blog | @mattmasson ), and me – we are all presenting the SSIS Design Patterns pre-conference session at the PASS Summit 2012 Read More... Posted Wednesday, August 22, 2012 8:00 AM by andyleonard | 2 Comments Filed under: Design Pattern, SSIS, SSIS 2012, PASS Summit 2012

• SSIS Design Patterns, the Book

  For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current Read More... Posted Monday, August 06, 2012 1:37 PM by andyleonard | 4 Comments Filed under: Design Pattern, Incremental, Database Developer, Developer Community, SQL Server, ETL, SQL Server 2008, Components, Business Intelligence, ETL Instrumentation, Writing, Books, Expression Language, Elegant Design, Deployment, Data Warehouse, Data Warehousing, SQL Azure, SQL Server 2012, BIML

• Presenting at Ohio North SQL Server User Group 1 May 2012!

  I am honored to present Using BIML as an SSIS Design Patterns Engine to the Ohio North SQL Server User Group 1 May 2012! This presentation is based on one of my favorite chapters in the upcoming book: SSIS Design Patterns scheduled for release this summer. Read More... Posted Friday, April 20, 2012 12:01 PM by andyleonard | 2 Comments Filed under: Design Pattern, SSIS, Presentations, SQL Server Community, SQL Server 2012

• MicroTraining: Managing Connections in SSIS 2012 24 Apr 2012 10:00 AM EDT

  Linchpin People is honored to present another (free!) microTraining event: Managing Connections in SSIS 2012 24 Apr 2012 10:00 AM EDT SSIS 2012 offers new functionality for managing SSIS Connections. In this presentation, I will demonstrate many ways Read More... Posted Wednesday, April 11, 2012 12:00 PM by andyleonard | 0 Comments Filed under: Design Pattern, Presentations, SQL Server Community, MicroTraining, SSIS 2012

• Updated SSIS Framework, Now Includes Reports

  I have built a beta version of Linchpin People ’s SSIS Framework, now including much-requested reports. You can grab the updated copy here . I appreciate any feedback you care to share. :{> Read More... Posted Wednesday, March 07, 2012 8:00 AM by andyleonard | 5 Comments Filed under: Design Pattern, SSIS, ETL, Presentations, SSIS Frameworks

• Designing an SSIS Framework

  In preparation for SQL Saturday #84 – Kalamazoo , SQLBits 9 , and the PASS Summit 2011 ; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised Read More... Posted Friday, September 16, 2011 8:00 AM by andyleonard | 20 Comments Filed under: Design Pattern, SSIS, ETL, Presentations, SSIS Frameworks

• Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

  Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners Read More... Posted Wednesday, September 07, 2011 6:00 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, ETL, SQL Saturday, Presentations

• Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

  I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here . Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM Read More... Posted Tuesday, July 19, 2011 1:58 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Developer Community, SQL Server, ETL, User Groups, Presentations

• Speaking at the Charlotte SQL Server Users Group Wednesday 18 May!

  I am honored to present SSIS Design Patterns to the Charlotte SQL Server Users Group Wednesday, 18 May 2011! If you read this blog and will be in the area Wednesday, stop by and say Hi! :{> Read More... Posted Monday, May 16, 2011 9:30 AM by andyleonard | 4 Comments Filed under: Design Pattern, SSIS, Developer Community, Presentations

• Presenting at SQL Saturday #70 - Columbia SC

  Introduction I'm honored to be presenting at SQL Saturday #70 in Coumbia SC 19 Mar 2011! Its always good to travel to places where I don't have to suppress my accent (what accent? I talk normal. Everyone else sounds funny...) and repeat my order at Waffle Read More... Posted Wednesday, March 09, 2011 8:00 AM by andyleonard | 2 Comments Filed under: Design Pattern, SSIS, Developer Community, ALM