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
David Peter Hansen has submitted 3 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

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?
Deployment to production is typically a manual process and can take a lot of time. Many companies use continuous integration for testing their software and continuous deployment to push code to production. But what about SQL Server development?
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.

Previous Sessions

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

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.