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 Consulting Manager at Advectas. 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.
http://davidpeterhansen.com/ http://feeds.feedburner.com/DavidPeterHansen

“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

Regional and language settings for Oracle client used with SQL Server linked server 11 Aug 2014
Today, I ran into a problem while migrating a Data Warehouse solution to another server. The solution have linked servers for extracting data from an Oracle source system. The query would go something like this: Everything had been migrated, but while running the extract job, which ran queries like ...

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 Johannesburg & 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 #327 Johannesburg on 29 August, as well as SQLSaturday #301 Cape Town on 5 September 2014. Having lived in South Africa, I have had the pleasure to visit Johannesburg, Cape Town and ...

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 ...