Category Archives: SSIS

How to skip SSIS package validation (new in SSIS extension v3.9)

Do you know that feeling.. “I have to quickly open that SSIS package and make a small change..” Well, the change itself does not require a long time, but sometimes the package validation during/after opening the package does take a … Continue reading

Posted in Business Applications, SSIS, Uncategorized | Leave a comment

SSIS 2017 – Scale Out – Master and Worker Responsibilities

In my previous post I explained the basics and types of scalability. Two participants are involved in the Scale Out scenario: Master and one or more workers. Master Responsibilities The master is managing the available workers and all the work … Continue reading

Posted in SSIS | 1 Comment

SSIS 2017 – Scale Out (Scalability Basics)

In this post (and maybe some follow-ups) I would like to introduce to you the Scale Out feature. SQL Server Integration Services (SSIS) are the data integration product within the SQL Server product. Introduced with SQL Server 2005 release it got … Continue reading

Posted in SSIS | 2 Comments

SQL Server 2017 – RC1 – Upgrade und Installation

Der erste Release Candidate der SQL Server 2017 Version wurde am 17. Juli veröffentlicht. Die enthaltenen Feature und Erweiterungen habe ich in einem Ankündigungspost zusammengefasst. Natürlich war ich gespannt auf die neuen Funktionalitäten und musste es gleich ausprobieren. Download starten … Continue reading

Posted in SQL Server, SSIS, SSRS | 1 Comment

TugaIT 2017 – SSIS Scale-Out slides

Thank you for joining my session at TugaIT 2017. The slides of my SQL Server Integration Services (SSIS) 2017 – Scale-Out talk are available for download here: Direct download link: TugaIT – SSIS 2017 – ScaleOut Download If you have any … Continue reading

Posted in Conference, SQL Server, SSIS, Uncategorized | Leave a comment

My sessions at TugaIT 2017

Another year is over and it’s already TugaIT 2017 week. The organizing team coming from nine different technical communities (AgileConnect, Cloud Pro PT, Devops Porto, netPonto, Office365 PT, OUGPT, Porto.Data, sharepoint.PT and SQLPort) have set together three days full of … Continue reading

Posted in Conference, PowerBI, SQL Server, SSIS, SSRS, Uncategorized | Leave a comment

SQLNexus 2017–I will talk about SSIS vNext

I am very happy to announce that I will (again) be part of the #SQLNexus conference in Copenhagen. From May 1 – 3 the conference takes place at the CinemaxX Fisketorvet – a cinema.. yes.. no kidding – a cinema. … Continue reading

Posted in Conference, MVP, SSIS | Tagged | Leave a comment

SQL Server 2016–Der Release Candidate 0 ist verfügbar (RC0)

Am 7. März wurde der Release Candidate 0 (RC0) des SQL Servers 2016 veröffentlicht. Mit dieser Veröffentlichung gibt es wieder zahlreiche neue Features und Verbesserungen. Die Ankündigungen im Überblick: First release candidate of SQL Server 2016 now available – https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/07/first-release-candidate-of-sql-server-2016-now-available/Continue reading

Posted in SQL Server, SSIS | Tagged | 1 Comment

I am speaking at SQLNexus in Copenhagen!

What a week – I’ve just got a mail with a very, very pleasing content: This means I will visit Copenhagen in May! This means I will take part of SQLNexus 2016! This means you will (if you attend SQLNexus) … Continue reading

Posted in Conference, SSIS | Tagged | Leave a comment

Morgen spreche ich auf der SQL Konferenz 2016

Morgen (25. Februar 2016) ist es soweit – der zweite Tag der SQL Konferenz 2016 findet statt. Ebenfalls morgen findet meine geplante Session zum Thema “SQL Server 2016 Temporal Tables and SCDs” statt. Ich werde in dieser Session das Konzept … Continue reading

Posted in Conference, SQL Server, SSIS | Tagged | Leave a comment