Free Licenses: Red Gate SQL Source Control for Oracle!

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 projects. It. just. works. It’s so cool to …
Continue reading Free Licenses: Red Gate SQL Source Control for Oracle!

Free Webinar: Medical Data Integration with SSIS 2012!

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 experience – some lessons learned, if you will. Beginning Wednesday, 10 Apr, at …
Continue reading Free Webinar: Medical Data Integration with SSIS 2012!

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

PASS Data Warehouse / Business Intelligence Virtual Chapter Co-Chair Web: http://bi.sqlpass.org | Email: [email protected] | Twitter: @PASSBIVC     Friday February 22nd 11am EST(US) Hacking the SSIS 2012 CatalogSpeaker: Andy Leonard URL: https://www.livemeeting.com/cc/usergroups/join?id=H4C3NK&role=attend&pw=7%3Ec%2FM5PwM Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it …
Continue reading Presenting Hacking the SSIS 2012 Catalog to PASS DW/BI VC Tomorrow!

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 and it is free. BimlScript.com contains a collection of sample, functional Biml snippets and code that demonstrate all kinds of …
Continue reading BimlScript: Incremental Load Design Pattern

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

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 be in the area that evening and if you …
Continue reading Presenting at the Greenville SC SQL Server Innovators Guild 5 Feb 2013!

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

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 tasks data integration and ETL developers …
Continue reading From Zero To SSIS Training: 4-8 Mar 2013 in Reston Virginia

Creating a Custom SSIS 2012 Task Series

A while back I asked myself: “Self, do you think it is possible to create a custom SSIS 2012 task using Visual Studio 2012 Express?” That question launched a quest to learn the answer. In this series of posts I describe what I learned: Creating a Custom SSIS 2012 Task – The Rambling Introduction Creating …
Continue reading Creating a Custom SSIS 2012 Task Series