Monthly Archives: September 2012

SQL Saturday #146 | Nashua, New Hampshire

SQL Saturday #146 | Nashua, New Hampshire

I’ve been invited to speak at SQL Saturday #146 in Nashua in October. I’ll be presenting two talks related to Data Movement: Efficient On-Premise to Cloud Data Transfer Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just … Continued

Lookups with really big reference tables

Lookups with really big reference tables

Recent customer issue: We are using the Lookup Transform to do joins in our Data Flows. Most Data Flows have more than one Lookup. The process worked fine in our development environment, but fails when we run in production because the source of the lookups have between 4-6 billion records each. How can we resolve … Continued

SSIS Design Patterns During the 24 Hours of PASS

Jessica Moss (Blog | Twitter) and Michelle Ufford (Blog | Twitter) will be presenting SSIS Design Patterns for Fun and Profit during the Fall 2012 24 Hours of PASS event to promote our pre-con session and the SSIS Design Patterns book. They are Session 15 on the schedule, which means they’ll be presenting on Friday, … Continued

Speaking at the DevTeach Montreal Conference

Speaking at the DevTeach Montreal Conference

I’ve been invited to speak at the DevTeach conference in Montreal this December (10th and 11th). I’ll be showing how to put together Enterprise Information Management (EIM) solutions using SSIS, DQS, and MDS. I’ve done EIM talks before (my favorite being the presentation I did with Matthew Roche at TechEd earlier this year), and will … Continued

Change Data Capture (CDC) for Oracle video now available

During my CDC presentation at TechEd North America I mentioned that the SSIS team would be posting a CDC for Oracle video, and I just realized I forgot to blog about it when it was announced on the SSIS team blog. Rakesh Parida (co-author on the SQL Server 2012 Integration Services book) this great video … Continued

Dynamic Execution of Child Packages with Different Parameters

Dynamic Execution of Child Packages with Different Parameters

SSIS 2012 introduces the concept of Parameters – a more explicit way of configuring your SSIS packages that you can use with the Project deployment model. The Execute Package Task was updated to support binding variables in the parent package to parameters in the child package (an alternative to the Parent Variable Configurations in SSIS … Continued

Book – Microsoft SQL Server 2012 Integration Services comes out September 17th

Book – Microsoft SQL Server 2012 Integration Services comes out September 17th

Update: Amazon is now reporting a release date of 9/17 although it appears you can order it immediately from the O’Reilly site. My second SSIS book – Microsoft SQL Server 2012 Integration Services (MS Press) – comes out on September 17th. This book takes a different approach than my Design Patterns book that came out … Continued

Speaking at the New England SQL Server User Group

I’ve been invited to do a presentation about Data Quality Services for the New England SQL Server User Group on October 18th. I’ll be presenting an in depth look at DQS, what some of our customers are currently doing with the product, and might even have time to show how DQS fits into larger Enterprise … Continued

Learn more about SSIS Design Patterns at the 2012 PASS Summit

Learn more about SSIS Design Patterns at the 2012 PASS Summit

We managed to bring together the entire author team for the SSIS Design Patterns book to run a pre-conference event at the 2012 PASS Summit. I posted about this when it was first announced, but since our book came out today, I thought it would be a good time to post a reminder. We’ve been … Continued

SQL Server 2012 Integration Services Design Patterns comes out tomorrow!

SQL Server 2012 Integration Services Design Patterns comes out tomorrow!

My first SSIS book – SQL Server 2012 Integration Services Design Patterns (Apress) – will be released tomorrow (9/5). In addition to some of the design patterns that I typically talk about in my presentations, it has some great content from the co-authors on the book – Andy Leonard, Tim Mitchell, Jessica Moss, and Michelle … Continued