Sessions & Content

Tags
Content Type
Search
Conference
A Deep Dive in SQL Server 2012 Data Warehousing
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.
BigData vs. Data Warehousing
: We are looking at the dawn of a new workload: BigData. In this session I will talk about what BigData is, and which BigData technologies Microsoft are working on.
Building an infrastructure to support real-time OLAP
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
FastTrack 101: How it makes your data analysis faster
SQL Server FastTrack References Architecture gives you the best practices and reference architectures from different hardware vendors to help you create a balanced environment for your data warehouse workload.
Loading Data Warehouse Dimensions in SSIS
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
Saturday Keynote: Inside SQL Server 2012’s ColumnStore Index
This talk will describe how the new ColumnStore index technology in SQL Server 2012 makes queries go faster. Covering details of the storage and execution model, how this model interacts with modern CPUs to deliver significant performance benefits.
So How Does BI Workload Impact the Database Engine? Part I
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
Temporal Snapshot Fact Table
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.
Turbocharge your DW Queries with Columnstore Indexes
Do you have data warehouse queries that run too long? In this session we’ll address how columnstore indexes speed up queries, best practices for creating and using columnstore indexes, and how to diagnose and treat potential issues.
<<1>>