The SQLUG.BE is proud to present the next event: an evening on SQL Server Integration Services.
Session 1: what's new in SSIS 2008 by Nico Verheire
A word about our speaker: Nico Verheire is a Business Intelligence Consultant for RealDolmen. For the last 4 years, he has been working almost exclusively on SQL Server (7, 2000, 2005), with a strong focus on SSIS, SSAS and SSRS. Nico currently holds an MCTS certification for SQL Server 2005 BI.
Integrating data with ADO.NET
Scripting with VSTA
Introducing the new lookup transformation (including caching)
Managing change in a data warehouse: how to use Change Data Capture (CDC) and use of the MERGE statement
Dealing with data quality: the Data Profiling Task
Session 2: Deep-dive session about improving SSIS performance given by Geert Vanhove
A word about our speaker: Geert Vanhove started his career in IT in 1991 as COBOL programmer on a mainframe system. In 1994 he chose to focus on databases, first on Sybase, later (1998) -almost- fulltime on Microsoft SQL Server. In 2005 he started his own company - DCOD - mainly focussing on performance tuning of SQL Server OLTP and BI platforms. He was closely involved with some of the most important SQL Server realizations in Belgium - as well in a development as in an operational context.
Abstract: This session will address some problems that might occur when a SSIS solution needs to scale because DB and data volumes to load are getting larger. This session is not only a statement of how you can improve your SSIS performance; the impact of each optimization step is shown in action throughout the demo package that will be the red wire of this presentation...
Date: Thu September 25, 2008
Agenda:18:00 - 18:30 Welcome with a drink & sandwich18:30 - 20:00 Part 120:00 - 20:30 Pause20:30 - 22:00 Part 222:00 - ... networkingMore information at the source.