Andy Leonard

SQL in the City Event Dates Announced!

andyleonard — Sat, 18 May 2013 06:00:00 GMT

Red Gate rocks. If you didn’t know that already, you know it now. The latest evidence to support this claim is the publication of the schedule for US SQL in the City events. They are: 9 Oct – Pasadena 11 Oct – Atlanta 14 Oct – Charlotte Registration for...(read more)

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

andyleonard — Sat, 18 May 2013 04:00:00 GMT

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)

Join Matt Masson and I for Developing Extensions for SSIS 22 May at 11:00 AM EDT

andyleonard — Fri, 17 May 2013 12:44:10 GMT

Matt Masson and I are co-presenting Developing Extensions for SSIS 22 May 2013 at 11:00 AM EDT. If you’ve never heard Matt present, you are in for a treat. Matt is knowledgeable (he helped build Integration Services 2012!) and entertaining. This is going...(read more)

Performance-Based Management and Andy’s Law

andyleonard — Fri, 10 May 2013 13:29:00 GMT

Let’s begin with an assertion: “People are more important than process.” – Andy, circa 2008 Whenever an enterprise or institution adopts a new process or policy, that policy should serve people and not shackle them. The nicest thing that can be said about...(read more)

Little Data Remains Important in Healthcare IT

andyleonard — Tue, 30 Apr 2013 14:31:24 GMT

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)

Scripting and SSIS - Free Webinar!

andyleonard — Wed, 17 Apr 2013 15:51:00 GMT

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)

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

andyleonard — Tue, 16 Apr 2013 14:27:00 GMT

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)

Presenting at SQL Saturday 189–Costa Rica!

andyleonard — Tue, 09 Apr 2013 15:00:00 GMT

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)

Free Licenses: Red Gate SQL Source Control for Oracle!

andyleonard — Fri, 05 Apr 2013 21:00:00 GMT

That’s right, I have two free licenses for Red Gate’s SQL Source Control for Oracle that are burning a hole in my virtual pocket! I like Red Gate’s SQL Source Control for SQL Server a lot. At Linchpin People , we are using SQL Source Control for several...(read more)

Free Webinar: Medical Data Integration with SSIS 2012!

andyleonard — Fri, 05 Apr 2013 15:00:00 GMT

Kent Bradshaw and I have been loading medical data for years. We worked together at Unisys and Molina Medicaid Solutions to build Extract, Transform, and Load (ETL) solutions for state Medicaid administrations in the US. We decided to share some of our...(read more)

Presenting Hacking the SSIS 2012 Catalog to PASS DW/BI VC Tomorrow!

andyleonard — Thu, 21 Feb 2013 17:57:00 GMT

PASS Data Warehouse / Business Intelligence Virtual Chapter Co-Chair Web: http://bi.sqlpass.org | Email: PASSDWBIVC@sqlpass.org | Twitter: @PASSBIVC Friday February 22nd 11am EST(US) Hacking the SSIS 2012 Catalog Speaker: Andy Leonard URL: https://www.livemeeting.com/cc/usergroups/join?id=H4C3NK&role=attend&pw=7%3Ec%2FM5PwM...(read more)

BimlScript: Incremental Load Design Pattern

andyleonard — Wed, 06 Feb 2013 12:00:00 GMT

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)

New Article at SQLServerCentral: Advanced Logging - Level 12 of the Stairway to Integration Services!

andyleonard — Wed, 06 Feb 2013 11:46:00 GMT

The latest Stairway to Integration Services article - Advanced Logging - Level 12 of the Stairway to Integration Services - is now live at SQLServerCentral.com ! :{>...(read more)

Presenting at the Greenville SC SQL Server Innovators Guild 5 Feb 2013!

andyleonard — Mon, 21 Jan 2013 13:00:00 GMT

I will be unveiling a shiny new presentation – Hacking the SSIS 2012 Catalog – at the SQL Server Innovators Guild in Greenville South Carolina 5 Feb 2013! The location of the meeting is: ECPI, Greenville, SC 1001 Keys Dr Greenville, SC 29615 If you will...(read more)

From Zero To SSIS Training: 4-8 Mar 2013 in Reston Virginia

andyleonard — Thu, 10 Jan 2013 16:00:00 GMT

Want to learn more about SSIS? I can help. In my course - From Zero To SSIS – I teach you how to effectively use SSIS to deliver data integration solutions. This is not a market-y survey of the bells and whistles contained in SSIS. I focus on the...(read more)