Two new SSIS SQL Server Technical Articles written by the SQLCAT team have been posted to the MSDN Library. They both focus on hybrid/cloud data […]
EIM presentation material from DevTeach Montreal
I presented an Enterprise Information Manager talk earlier this week at the DevTeach Montreal conference. Unlike my previous talk from TechEd North America, which tackled […]
Slides from DQS presentation
A big thank you to everyone who came to tonight’s DQS presentation for the New England SQL Server User Group. As promised, you can find […]
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 […]
TechEd and the SQL Server 2012 Virtual Labs
I had a fantastic time at TechEd North America this year. I didn’t get a chance to attend many sessions, but thankfully they are all […]
SSIS & EIM Talks From TechEd North America 2012 Now Available
The recordings of my the SSIS sessions I presented at TechEd North America 2012 are now available online. Incremental ETL Using CDC for SQL and […]
SSIS Catalog Presentation
This talk is similar to the What’s New in Integration Services for SQL Server 2012 presentation, but contains some additional slides around the architecture of […]
What’s New in SSIS for SQL Server 2012 – Slide Deck
The slide deck for the What’s New in SQL Server Integration Services in SQL Server 2012 presentation is now available (embedded below). Typically when I […]
Getting Started with DQS and MDS
If you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), there are some fantastic resources available on Technet. The […]
AlwaysOn Multi-Subnet Failover and SSIS
Updated 2012-05-11: Updated the .NET Framework update link to point to 4.0.3, as it has some additional updates for AlwaysOn. If you plan on using […]