Platinum Sponsor

David Peter Hansen

David Peter Hansen is a Microsoft Certified Master (MCM) and has over a decade of experience with database development and administration on SQL Server and the Microsoft Business Intelligence platform. Today, he works as ICT Database Developer at United Nations Office for Project Services (UNOPS). He specializes in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions. He is a frequent speaker at conferences, and have given talks in Europe, USA, and South Africa.

“Just use partitioning” is the answer you hear, when you need to manage very large data sets in your Data Warehouse. But how do you design and implement it? We will walk through different ways to design partitioning, including layered partitioning.
In this session, you will learn what SSIS is, what components it consists of, and how to use the SSIS catalog to track the execution of packages and how to troubleshoot packages.
In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems, and how the control flow and data flow engine work.

Blog posts RSS

Integration Services for the DBA 18 Jul 2014
The slide deck for my talk at SQLBits XII about SQL Server Integration Services (SSIS) for the DBA.

SQLSaturday #301 Cape Town pre-con: Understanding SSIS internals and performance tuning 10 Jul 2014
I am very happy and super excited to announce that I will be doing a full day pre-con the day before SQLSaturday #301 Cape Town on 5 September 2014. Having lived in South Africa, I have had the pleasure to visit Cape Town and Stellenbosch on a number of occasions. I must say, I can’t […]

Speaking at SQLBits, SQL Server Days, and PASS Summit 2014 08 Jul 2014
I am very honored and happy to announce that I will be speaking at three major SQL Server conferences this year. SQLBits XII, 17-19 July, UK: I spoke last year for the first time at SQLBits, and am so happy they have invited me back. I will be giving two talks; one on SSIS internals […]

MSBuild error (and fix) with Visual Studio 2013 SQL Server tooling and SQL Server 2014 21 Apr 2014
To show the possibilities with continuous integration with SQL Server development, I decided to spin up a virtual machine with Visual Studio 2013, Team Foundation Server 2013, and SQL Server 2014. While setting it up, I ran into an error that I thought I’d share here. If you want to know more ...

SQL Server Integration Services (SSIS) internals and performance 06 Mar 2014
The slide deck for my talk at SQLSaturday #280 Vienna about SQL Server Integration Services (SSIS) internals and performance.