Come and join us for an evening of SQL Server discussion, as well as the two formal sessions by Chris Testa-O'Neil and Tony Rogerson there will be a chance for other folk to present, we will have some topic discussions - if you have a specific topic to talk around, perhaps a problem at work, something you've always wanted to know then bring it to the meeting.
Pizza will be provided.
A copy of Windows 7 Ultimate and Brian Larson Business Intelligence book is available to win
Registration is essential.
Loading a datawarehouse using SQL Server Integration Services (SSIS)
Chris Testa-O'Neil, SQL Server MVP
Exploring tips and tricks that will enable you to understand the techniques that can be used to populate a data warehouse with data.
This session will focus on the data flow and control flow components that can be applied to SQL Server 2005 and SQL Server 2008. Techniques that will be explored include: Using variables to control datawarehouse loads. Managing dimension data with Slowly Changing Dimension. Inserting data into fact tables with the cache and lookup transformations.
Database Design: Normalisation/Denormalisation and using Surrogate Keys
Tony Rogerson, SQL Server MVP
A talk around Normalisation and Denormalisation, use of Surrogate Keys, Performance and scalability problems caused around joins because of Normalisation; some indexing bits and bobs like index intersection.