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