0845 643 64 63

Monthly Archives: February 2012

SQLBits X talk – Loading Data Warehouse Dimensions

I’m thrilled to have been asked to present another session at SQLBits X, especially so as it’s set to be the biggest and best Bits yet.

It’s the official UK launch of SQL Server 2012, and as such there’s an impressive collection of Microsoft folk attending and presenting, alongside the MVPs and internationally renowned speakers that we now come to expect at SQL Bits.

The Saturday is now sold out, but (as of writing this) there are still some places available on the Thursday and Friday, but these are unlikely to stay available for long so head to www.SQLBits.com and get your name down asap.

Loading Data Warehouse Dimensions

The session that I’ll be presenting will cover different techniques of using SSIS to load data into data warehouse dimensions. Specifically a performance comparison of the methods when loading Type 2 slowly changing dimensions, as well as showing the impact of using solid state storage such as Fusion IO.

I’ll also be covering the details of how to use the T-SQL Merge statement to take care loading dimensions, and showing why it’s now my preferred approach.

SQL User Group Community

I’ll also be there representing SQLMidlands, a SQL Server user group in Birmingham. User group leaders from around the UK will be presenting a session on Saturday lunchtime, as well as staffing the community corner.

If you’re interested in getting involved with your local user group, if you just want to find out more, or are at your first SQLBits and want a friendly face to chat to – find me & the other UG leaders at the community corner.

Look forward to seeing you there!

Power BI Sentinel
The Frog Blog

Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.

This is a collection of thoughts, ramblings and ideas that we think would be useful to share.

Authors:

Alex Whittles
(MVP)
Reiss McSporran
Jeet Kainth
Jon Fletcher

Data Platform MVP

Power BI Sentinel
Frog Blog Out
twitter
rssicon