SQL Supper with our hosts 7Digital
Nearest Tube : Old Street.
18:00 Registration, hello & welcome
18:15 Geoff Clark (MCM) : End-to-End DW data loading
Options to move data from Source to Data Warehouse and Intermediate data stores. Techniques to move data: CDC, Replication, Data based queries. Importance of Automation, automation options: T4 templating, T-SQL from T_SQL, BIML and others. Demos of these tools in action, comparison of strengths and weaknesses. Automating the deployment, Data Tools and MSBuild.
Geoff has worked with SQL Server since 1991, he was the technical architect at BAA for one of the earliest SQL database project, going live with the original betas’ of both Windows NT and SQL Server on multiprocessor computers. Geoff began his professional career as a consultant for ICL based in the City of London, designing and capacity planning network database based transaction processing and reporting applications before moving to Ingres relational databases on Sun and ICL Clan computers and then SQL Server.
Currently Geoff is working on a data migration in a large CI environment. His recent projects included designing an ETL solution based on CDC technology, data migration and warehouse design and ETL.
Geoff has presented at SQL User Groups and SQLBits.
19:30 David Peter Hansen (MCM) : SSIS internals and performance
You have worked with SQL Server Integration Services (SSIS) for a few years, but would like to know what is happening behind the scene. Join this session to get a deep dive into the internals of SSIS, and find out what is happening when your packages are executed. You will learn about the data flow engine, what buffers are used for, how the different transformations behave, and what execution trees are and why they are important. Understanding the SSIS internals is not only very interesting in itself, but will also make you able to respond to design and performance problems - as well as solve them.