SQLLunch has arrived in London.
12:30 sharp start , downstairs bar at the Golden Fleece EC4N 1SP.
Agenda :
12:30 - 12:31 Welcome and hello
12:31 - 1:15 Remote Presentation : Josef Richberg ( @sqlrunner )
SSIS
Tips&Tricks:
Learn
some of the quirks and capabilities of SSIS. Learn about the pitfall of
"parallel path choicing". Use
the Script Component as a data source (to solve complex sourcing issues) and as
a data destination (to
get around the identity column conundrum). See how use Script Tasks to
build directory scanners for
efficient file import techniques. Learn how to build and use Named Pipes
to improve workload performance.
We'll also go over some the tuneable properties of the Data Flow object.
A SQL practitioner for over 18 years
specializing in performance & tuning. Josef is currently work for Penguin
Group (US), designing, enhancing, and improving, the sql experience for many of
the data warehouse applications. Josef has been heavily involved in designing and
implementing SSIS packages and is the RedGate '2009 Exceptional DBA'
award winner.