17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor
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 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.
http://davidpeterhansen.com/ http://feeds.feedburner.com/DavidPeterHansen
David Peter Hansen has submitted 4 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

In this session, you will learn what SSIS is and which components it consist of, how to use the SSIS catalog to track the execution of the package 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.
In this session, you will learn about minimal logged operations. You will also learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL.
In this session, you will learn about the technical perspectives of continues integration and continues deployment, and how you can use SQL Server Tooling for Visual Studio 2013 and Team Foundation Server 2013 to move to a continues deployment model.

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 and which components it consist of, how to use the SSIS catalog to track the execution of the package 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

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.The post SQL Server Integration Services (SSIS) internals and performance appeared first on David Peter Hansen.

Create Data Warehouse extract tables from SQL Server source system 27 Jan 2014
I have often found that I needed a quick script for giving me CREATE TABLE statements for each table in a source system database, so I could create these tables in my extract schema in my Data Warehouse. This can obviously be done using SQL Server Management Studio, but I found that I would then ...

When does SQL Server partition split move data? 19 Nov 2013
One of the many benefits when using table partitioning in SQL Server is the metadata only operations, such as switch, split, and merge. However, if we are not careful, splitting partition can potential take a long time if data end up being moved between two partitions. In this blog post we will ...

10 tips and tricks for better SSIS performance 06 Nov 2013
Your SSIS packages are taking longer than they should, but you are not sure what to do about it. This session gave 10 tips and tricks for gaining better performance. Not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use ...

First look at the In-Memory OLTP database engine component in SQL Server 2014 11 Oct 2013
You may have heard about the new in-memory OLTP database engine component (formerly known as Hekaton) in SQL Server 2014, but would like to see it in action. I gave this demo-packed talk at Microsoft Campus Days 2013 in Copenhagen, where we took a first look at the in-memory OLTP capability, where ...