Sign up

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

Speakers

James Rowland-Jones

microsoft.com/en-us/sql-server/sql-server-2019

James Rowland-Jones's previous sessions

Agnostic, Hybrid Big Data Integration using PDW and PolyBase
PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.
 
Demonstrating PDW integration with Hadoop & Polybase
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.
 
The Art of War-Fast Track Data Warehouse & Fragmentation
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!