Category:Uncategorized

The SSIS Data Pump – Level 2 of the Stairway to Integration Services has been republished at SQL Server Central! You can find additional articles in the Stairway to Integration Services series here. Enjoy! :{>

This post was inspired by a recent conversation with a DBA followed by reading The Curse of Relational Databases (especially the comments) posted at Grant Fritchey’s SQL Server Central blog. I have two points to make: As of mid-2014 a physical person is required to properly administer a production relational database instance. The title of …
Continue reading You Need a DBA

I am honored to present Using Biml as an SSIS Design Patterns Engine to Lynchburg SQL Server Users Group Thursday, 26 Jun! Abstract  Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of Biml in this session. …
Continue reading Presenting Using Biml as an SSIS Design Patterns Engine to Lynchburg SQL Server Users Group 26 Jun!

Deployment and Execution – Step 18 of the Stairway to Integration Services is live at SQLServerCentral.com!   Enjoy!   :{> 

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 …
Continue reading Presenting Enterprise Information Management in SQL 2012 and SQL 2014 in Reston 16 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 techniques for developing, instrumenting, monitoring, and …
Continue reading Presenting SSIS 2014 Data Flow Tuning Tips and Tricks in Boston 14 May!

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

Silly question? Maybe. Hang with me, please. This will be short – a couple / three minutes, tops. Do you know more than you did six months ago? A year back? Yep, we both know you do. How did you feel back then, before you knew what you know now? Did you sense there was …
Continue reading Do You Learn?

Multiple Flexible Source Locations – Step 17 of the Stairway to Integration Services is live at SQL Server Central! :{>

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