Data Warehousing features in SQL 2008

2009

TL; DR

SQL Server 2008 has a ton of great features to help you in your data warehousing endeavours. In this session find out what they are and how you can best use them.

Session Details

Features to be covered include:

Resource Governer
Compression
STAR Joins
Parallelism Improvements
Minimally Logged Inserts
Read Committed Snapshot Isolation Enhancements
SSIS Improvements
Anything else that springs to mind...:o)

3 things you'll get out of this session

Speaker

James Rowland-Jones's previous sessions

Maximise compute performance with Azure SQL Data Warehouse - 2018

Advanced Topics for Azure SQL Data Warehouse - 2016

Agnostic, Hybrid Big Data Integration using PDW and PolyBase - 2015

Demonstrating PDW integration with Hadoop & Polybase - 2014

The Art of War-Fast Track Data Warehouse & Fragmentation - 2011

Fast Track Foundations: Get Serious about Sequential I/O - 2010

Data Warehousing features in SQL 2008 - 2009

Optimistic Concurrency Internals - 2009

Data warehousing features in SQL 2008 - 2009

I/O! I/O! It’s off to disk we go... - 2008

Head in the Cloud... - 2008