On September 25th we organize our next SQLUG.BE event. We have 2 session on Integration Services. Registration is needed and is open.
Session 1: what's new in SSIS 2008 by Nico Verheire
Abstract:
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
Level: 200
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.
Session 2: Deep-dive session about improving SSIS performance given by Geert Vanhove
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...
Level: 300
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.
Date: Thu September 25, 2008
Agenda:
18:00 - 18:30 Welcome with a drink & sandwich
18:30 - 20:00 Part 1
20:00 - 20:30 Pause
20:30 - 22:00 Part 2
22:00 - ... networking
The event-sponsor is Kohera in Kontich:
Location:
Het Rekreatief vzw
Doornstraat 600
2610 Wilrijk
A route description can be downloaded here.
Registration is needed and is open.
Registration will be closed on September 23