david_peter_hansen.jpg

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.
When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible?
Your relational Data Warehouse is suffering from performance problems. In this session we will take a look at some of the most common performance problems that tend to occur in a relational data warehouse.

Blog posts RSS

First time speaker at PASS Summit: How I prepared 23 Dec 2014
PASS Summit 2014 was the first time I was selected to speak at a truly major tech conference. While I have spoken at over 30 conferences over the past two years, some of them with several hundreds of participants, this one is different; PASS Summit had 5,900 registrations. My session had 233 ...

Upgrading to SQL Server 2014 – Campus Days talk (slides in Danish) 27 Nov 2014
Below you will find slides, demos, and references for my Campus Days talk on “Upgradring to SQL Server 2014”. The slides are in Danish, as it was a Danish conference. Slides Demos Demos can be found at github. Further reading / references Recommended Intel processors for SQL Server 2014 OLTP ...

Integration Services (SSIS) for the DBA 05 Nov 2014
Below you will find slides, demos, and references for my PASS Summit 2014 talk on “Integration Services (SSIS) for the DBA”. Slides Demos Demos can be found at github. Further reading / references SSIS For DBAs Perfmon Counters for the Integration Services Data Flow Engine SSIS Catalog ...

Bulk load: methods for better data warehouse load performance 01 Nov 2014
Slides and demo scripts are now available for my talk at SQLSaturday #337 Oregon today. Abstract When loading a data warehouse you want the data inserted into the tables as fast as possible. You know you have to use bulk loading, but what do you need to do to ensure a minimal footprint on the ...

SQLRally Nordic in Copenhagen – Full day training on SSIS internals and performance 24 Oct 2014
On 2 March 2015, I am giving a full day pre-conference training session on SSIS internals and performance at SQLRally Nordic in Copenhagen You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some ...