Browse by Tags

• 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)
• Ethics
• ETL
• ETL Instrumentation
• From Zero to SSIS!
• Incremental
• Leadership
• 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 in Richmond and Charlotte this month!

  I have a busy January ahead... Read More... Posted Friday, January 02, 2015 9:33 AM by andyleonard | 0 Comments Filed under: SSIS, Presentations, SQL Server Community

• A Biml Case Study

  Business Intelligence Markup Language (Biml) is a SQL Server Integration Services (SSIS) design patterns engine. A Story of Productivity A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing Read More... Posted Wednesday, November 26, 2014 8:37 PM by andyleonard | 0 Comments Filed under: SSIS, ETL, Business Intelligence, Presentations, Professional Development, SQL Server Community, BIML

• Some Thoughts on Event Speaker Selection

  I write this from the perspective of experience. I’ve helped organize dozens of events over the past ten years. Feel free to take the parts of this advice that help and discard the parts that don’t. Enjoy! Planning an event is hard work. If you’ve never Read More... Posted Wednesday, November 26, 2014 7:06 AM by andyleonard | 1 Comments Filed under: Developer Community, PASS, SQL Saturday, Leadership, Presentations, Ethics, PASS Community, Community

• Presenting on Biml to the SQL Midlands in Birmingham (UK) 11 Sep 2014!

  I am honored to present “Using Biml as an SSIS Design Patterns Engine” to SQL Midlands in Birmingham 11 Sep 2014 starting at 18:15! As at SQL Supper the evening before, the other presenter is my esteemed friend, Chris Webb ( @TechniTrain ). Chris’ session Read More... Posted Wednesday, August 27, 2014 5:00 AM by andyleonard | 2 Comments Filed under: SSIS, Presentations, BIML, BimlScript

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