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!

The Frog Blog

I'm Alex Whittles.

I specialise in designing and implementing SQL Server business intelligence solutions, and this is my blog! Just a collection of thoughts, techniques and ramblings on SQL Server, Cubes, Data Warehouses, MDX, DAX and whatever else comes to mind.

Data Platform MVP

Frog Blog Out
twitter
rssicon