05 April 2010 14:24
tonyrogerson
Tuesday 6th Manchester SQL User Group - Chris Testa-O'Neil (Loading a datawarehouse using SSIS) and Tony Rogerson (Normalisation/Denormalisation, Locking and Indexing)
Chris will give a talk on Loading a datawarehouse using SQL Server Integration Services, Tony Rogerson will give a talk on Database Design: Normalisation/Denormalisation and using Surrogate Keys - practicalities/pitfalls and benefits in Microsoft SQL Server.
Registration is essential which you can do here:
http://sqlserverfaq.com?eid=218.
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
http://sqlblogcasts.com/blogs/testas
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
http://sqlblogcasts.com/blogs/tonyrogerson
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.