Browse by Tags

• Agile
• ALM
• Automation
• BIML
• BimlHero
• BimlScript
• Books
• Business Intelligence
• Code Camp
• Community
• Components
• Data Integration
• Data Warehouse
• Data Warehousing
• database design
• Database Developer
• Deployment
• Developer Community
• DevOps
• DILM
• Disruptive
• EIM
• Elegant Design
• EnterpriseDNA
• ETL
• ETL Instrumentation
• Executing SSIS
• Expression Language
• Incremental
• Linchpin People
• measurement
• Microsoft
• MicroTraining
• PASS
• PASS Community
• PASS Summit 2010
• PASS Summit 2011
• PASS Summit 2012
• PASS Summit 2015
• Precons
• Presentations
• Security
• SQL Azure
• SQL Saturday
• SQL Server
• SQL Server 2008
• SQL Server 2012
• SQL Server 2014
• SQL Server Community
• SQLLunch
• SSIS
• SSIS 2012
• SSIS 2014
• SSIS 2016
• SSIS Administration
• SSIS Catalog
• SSIS Design Patterns
• SSIS Frameworks
• SSIS Performance
• SSIS Snack
• User Groups
• Writing

• The Recording for DILM DevOps: SSIS Frameworks + Design Patterns is available!

  The recording for the Enterprise Data & Analytics webinar “DILM DevOps: SSIS Frameworks + Design Patterns” is available here . It’s free! But registration is required. Enjoy! :{> Read More... Posted Thursday, January 21, 2016 9:54 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, DILM, DevOps, EnterpriseDNA

• Biml 103–Automating SSIS Design Patterns with Biml Recording is up!

  The Biml 103 webinar “ Automating SSIS Design Patterns with Biml ” recording is now available. Registration is required, but it’s free. Enjoy! :{> Read More... Posted Thursday, January 14, 2016 8:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, BIML, BimlScript, SSIS Design Patterns, Automation

• 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: Design Pattern, SSIS, Agile, SQL Server, ETL, Business Intelligence, ETL Instrumentation, Elegant Design, SQL Saturday, Presentations, Data Warehouse, SQL Server Community, SSIS Frameworks, Community, SSIS 2012, BIML, SSIS Catalog, BimlScript, Precons, SSIS 2014, SSIS Performance, SSIS Design Patterns, DILM, SSIS Administration, DevOps, Executing SSIS, Automation, Data Integration, SSIS 2016, BimlHero

• Biml 101 – A Free Webinar 18 Nov 1:00 PM EST

  If you’ve heard the buzz about Business Intelligence Markup Language ( Biml ) but never used it, you may be curious about how Biml works and how it can help reduce the amount of time required to develop SSIS packages. In this 100-level presentation, BimlHero Read More... Posted Wednesday, November 04, 2015 2:00 PM by andyleonard | 2 Comments Filed under: Design Pattern, SSIS, Disruptive, BIML, BimlScript, SSIS Design Patterns, Automation, BimlHero

• #Biml at the PASS Summit 2015

  I’m excited that PASS included Biml in the Summit 2015 this year. It’s the first year for this topic, at least officially. Unofficially, Biml topics have been presented the past couple years. The technology is maturing and receiving the exposure it so Read More... Posted Sunday, October 25, 2015 2:01 PM by andyleonard | 0 Comments Filed under: Design Pattern, ETL, BIML, BimlScript, PASS Summit 2015, Data Integration

• Own the SSIS Design Patterns E-Book for $10–Today Only!

  Own the SSIS Design Patterns (2nd edition - updated for SSIS 2014) ebook today for just $10! :{> Learn more:  Stairway to Biml Linchpin People Blog: SSIS Stairway to Integration Services Read More... Posted Thursday, July 30, 2015 1:30 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS

• Real World SSIS: A Survival Guide, 8 May, Baltimore

  My friend and fellow Linchpin, Tim Mitchell ( blog | @Tim_Mitchell ) will deliver a day-long seminar titled Real World SSIS: A Survival Guide the day before SQL Saturday – Baltimore (9 May). Attend and learn more about: Handling warnings, errors, and Read More... Posted Wednesday, April 08, 2015 9:24 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Developer Community, ETL, SQL Saturday, SQL Server Community, PASS Community, Community, BIML, Linchpin People, SSIS Catalog, SSIS 2014, SSIS Performance, SSIS Design Patterns, Security, SSIS Administration

• 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 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

• 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 | 4 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