Presenter: Matt Batalon
Topic: SSIS Design Patterns for Better Performance
These days ETL developers face two common problems:
1: They are managing more and more ETL processes that have to complete in a shorter time window, and
2: their data is continuously growing. Today, more and more data has to be extracted from multiple sources, transformed, and loaded into its intended destination faster than ever before. SQL Server Integration Services is a robust product with lots of different options to choose when building an ETL package. Of course speedy hardware helps when it comes to performance, but have you ever wondered how the decisions you make when developing a package can affect the package’s performance? Come to this session to explore how SSIS handles memory, and have a better understanding of how certain tasks and transformations can affect your package’s performance.
Matt has 15 years of experience in the Information Technology field with a focus on software development and database administration. For the past ten years, he has worked extensively with Microsoft SQL Server and the .NET framework.
He has a Bachelors Degree from Bryant University with a concentration in Computer Information Systems, and also holds the Microsoft Certified Information Technology Professional (MCITP) Certification in Database Administration.