Twitter Updates

    follow me on Twitter

    Monday, September 01, 2008

    Next SQLUG.BE session on SSIS

    We announced our next SQLUG.BE event on Integration Services. We will have 2 sessions by 2 top speakers. Looking forward to see you there.


    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.

    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

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

    Level: 300

    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

    Location:
    The event-sponsor is Kohera in Kontich:
    Veldkant 33a
    2550 Kontich

    A route description can be downloaded here.

    Registration is needed and is open.

    Registration will be closed on September 23

    No comments: