Sessions & Content

Search
Content Type
Conference
Tags
A Deep Dive in SQL Server 2012 Data Warehousing Dejan Sarka
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
Building an infrastructure to support real-time OLAP Dr John Tunnicliffe
Users love flexible analytics but hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want
Loading Data Warehouse Dimensions in SSIS Alex Whittles
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Temporal Snapshot Fact Table Davide Mauri
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
<<1>>