Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
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 demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
Unit and integration testing for SSIS packages can be challenging. Come to this session to learn how to leverage open-source tools to drive the testing of your packages and the resulting data.
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.