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 of SQL Server 2014, including: Integrated In-memory technology AlwaysOn HA / DR for ...

On 31st March 2014 I released version 1.2.0.0 of SSIS Reporting Pack, my open source project that aims to enhance the SSIS Catalog that was introduced in SSIS 2012. This is a big release because it includes an entirely new feature  -the Restart Framework. Introduction The Restart Framework exists to cater for a deficiency within SSIS, ...

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… :{>

My latest article in the Stairway to Integration Services, Flexible Source Locations - Level 16 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{>

An Overview of SSIS Parameters - Level 15 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{>

SQL Saturday #277 is going to be held 22 Mar 2014 in Richmond Virginia! There will be three day-long pre-conference sessions on Friday 21 Mar: Performance Tuning and Troubleshooting Like a Pro by Robert L. Davis (@sqlsoldier) Murder They Wrote by Wayne Sheffield (@DBAWayne) and Jason Brimhall (@sqlrnnr) SSIS Design Patterns by me ...

I am honored to present “I See A Control Flow. Now What?” at SQL Saturday Nashville on Saturday 18 Jan 2014! There are a bunch of really cool presentation scheduled, including a few Linchpins! I hope to see you there! Register here. :{>

SQLPASS TV channel has been published the session Automate Your ETL Infrastructure with SSIS and PowerShell that Allen White (@SQLRunr) has done during the PASS Summit 2013.  Abstract Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single ...

Let me point out the upcoming live events scheduled for December 2013 organized by PASS Business Intelligence Virtual Chapter.   Create and Load a Staging Environment from Scratch in an Hour with Biml Date: Thursday 12 December Noon PST / 3 PM EST / 8 PM GMTSpeaker: Scott CurrieURL: ...

A long long long time ago (in 2006 in fact) I published a blog post entitled Suggested Best Practises and naming conventions in which I suggested a bunch of acronyms that folks could use to prefix object names in their SSIS packages, thus allowing easier identification of those objects in log records, here is a sample of some of those suggestions: ...