Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Skip Navigation Links
RSS
Login or Join
Skip Navigation Links

Session Details - Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite

Slowly Changing Dimensions (SCDs) in their various forms are a standard part of most BI implementations and yet they still manage to confound many developers when they come to implement them. Drawing from experience gained in the field, this session will briefly describe what an SCD is, what it does, how it can best be modelled in both the relational and OLAP layers and which of the various options available in SQL Server 2008 is the best way of loading it. Topics covered may include: - "There are 6 types of SCD? WHAT?!?"; - "To Snowflake or not to Snowflake?"; - "The SCD Wizard is brilliant and should always be used"; * - "CHECKSUM(): the solution to all my problems"; * - "MERGE - the obligatory SQL Server 2008 bit": It may also try and present an adaptable and performant strategy for loading SCDs that actually works. * - May not be true
Colin Hardie
Colin Hardie is a Senior BI Consultant with Information Management Group (IMGROUP), winners of the Microsoft Global Business Intelligence Partner of the Year award for the past four years. Previously Colin worked as a Technical Architect for a large pharmaceutical Information Services provider. Colin has worked with the SQL Server BI stack since 2001 and is a Microsoft Certified IT Professional Business Intelligence Developer. His main fields of expertise are SSIS and SSAS. Colin lives in London with his wife and two children.

To view the presentation below in full screen double click on it.


Click here to view in local media player

Due to the size of these files we can only provided streamed versions.

Other sessions from this conference

A Testing Time... (Downloads) (Video)
A walk down memory lane (Downloads) (Video)
Advanced T-SQL (2005 and 2008) (Downloads) (Video)
Data Vizualisation - Make your reports useful to business - No more "Speed Dials" (Downloads) (Video)
Does your cube support your users reporting needs? (Downloads) (Video)
Don't try this at work ! (Downloads) (Video)
End to End Report Creation and Management using Microsoft SQL Server 2008 (Downloads) (Video)
Getting more value from your data through data mining. (Downloads) (Video)
Head in the Cloud... (Downloads) (Video)
How to approach zero downtime database upgrades (Downloads) (Video)
Indexes Basically (Downloads) (Video)
Microsoft's integrated end-to-end BI offering. (Downloads) (Video)
Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse (Downloads) (Video)
Small Problem - Simple Solution: Lookup Tables (Downloads) (Video)
SQL Server – Under New Management (Downloads) (Video)
SQL Server 2008 for Developers (Downloads) (Video)
Understanding Query Cache and Query Plans (Downloads) (Video)
Useful Sql'y stuff that I've picked up over the years (Downloads) (Video)
Where’s my data? An introduction to Spatial Queries in SQL Server 2008 (Downloads) (Video)