SSIS 2012 Configuration Guide – Part 1: Introduction
Configuration handling in SSIS was not always the easiest part. One of the problems were the different possibilities we had …
Category Archives: ETL
Parallel Data Warehouse – POC lessons learned Part 3
The first part of the PDW lessons learned series gave an introduction about the goals of the POC, a customer …
Design SSIS for Performance and Scale – Parallelism strategies, Part 1
After looking at our baseline numbers I will now explain the parallelism strategies we are able to use with SSIS. …
Design SSIS for Performance and Scale – Baseline tests
In the first post of the series I gave an introduction to some general aspects of performance tuning, our reference …
SSIS Performance Tuning–Monitoring & Data Collection
In my first post about my tuning series I wrote about the general methodology how tuning works: SSIS Performance Tuning …
Design SSIS for Performance and Scale
I’d like to start a new series about SSIS design pattern for performance and scale. I already introduced the general …
Parallel Data Warehouse (PDW) POC – lessons learned
The first version of Microsoft’s Parallel Data Warehouse is out for a while, now I had the chance to get …
SSIS Performance Tuning – Methodology and general approach
Performance tuning is the improvement of system performance. The motivation for such activity is called a performance problem, which can …
PASS SQLRally 2011 Nordics – delivered
This was my first session for the PASS Community. I presented together with my friend Alexei from SQLCAT about “High …
Data Warehouse reference architecture – Staging & Archive
In my last post I presented the Data Warehouse reference architecture that I use to explain design principles and ETL …
