Data Analytics Junkie

Analytics and AI on the Microsoft platform – Marcel Franke –


Data Loading

SSIS 2012 Configuration Guide – Part 2: Scenarios, Setup and Migration

This post is the second part of the SSIS 2012 configuration Guide. The first part gave a general introduction about the new deployment models, parameters, environments and the SSIS catalog. In the second part of the guide I will describe... Continue Reading →

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 before SQL Server 2012: XML configuration files Environment variables Registry entries Parent package variables SQL Server configurations In SSIS 2012... Continue Reading →

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. For this purpose I introduce my scale map. Scale map The map is divided into partition strategies and insert strategies.... Continue Reading →

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 architecture and our data model as well as some general SSIS tuning techniques. The second post will concentrate on some... Continue Reading →

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 - Methodology and general approach Now I’d like to talk about what we need to collect, what the tools are... Continue Reading →

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 methodology of performance tuning in an earlier blog post SSIS Performance Tuning. The reason why I decided to write about... Continue Reading →

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 be real or anticipated. In many cases the system performance decreases for example with increasing load volumes or the number... Continue Reading →

Vote for missing functionality in SSIS in SQL Server Denali CTP3

If you have some minutes left, pleas vote the following items on Connect for SSIS features missing in SQL Server Denali: Filter SSIS events: It is currently not possible to choose the events that need to be logged within the... Continue Reading →

Blog at

Up ↑