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