Network, learn, ask a question, meet other folk, get fed - these are all
things that happen at user group events. These events are a really great opportunity to socialise in an informal
Remember to tell your friends and the people you work with; make sure
you register as soon as you can.
Agenda is subject to alterations on the timings as we finalize the complete
6:00 - 6:20pm Registration and networking
Meet and greet.
6:20 – 6:30pm PASS & London Chapter Updates
6:30 - 7:30pm 1st Session - David Hansen
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.
David Peter Hansen is a Microsoft Certified Master (MCM) and has over a
decade of experience with database development and administration on SQL
Server and the Microsoft Business Intelligence platform. Today, he works
as Senior Manager at Hitachi Consulting. He specializes in developer
coaching as well as scalable architecture and performance tuning on
large-scale data warehouses and BI solutions. He is a frequent speaker
at conferences, and have given talks in Europe, USA, and South Africa.
7:30 - 7:50pm Break, Food & Networking
7:50 - 8:50pm 2nd Session - Neil Hambly
Effective Index Partitioning, Compression Strategy
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can often see substantial gains. Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect. Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.