PASS Summit 2010
Register Now

ROI Justification



PASS Facebook PASS LinkedIn PASS Twitter

Premier Sponsor:

Platinum Sponsor:
Best Practices for Data Warehousing with SQL Server 2008 and 2008 R2
SQL Server 2008 and 2008 R2 provide a strong foundation for building data warehouse applications. This talk describes how to use them most effectively for data warehouses and data marts. We describe best practices for choosing a processor, storage, and memory configuration for your DW, including a brief description of Fast Track reference architectures. We cover how to choose file and file group structures, and how to define index structures to reduce and speed up I/O. We describe data modeling with a focus on star schemas. We cover how to use pre-built aggregates to speed up queries, including use of indexed views and user-defined summary tables. We describe how to load data into your data warehouse efficiently during a typical nightly load cycle. In addition, we briefly review new features for DW in SQL Server 2008 and 2008 R2, such as few outer rows parallelism, partitioned table parallelism, MERGE, minimally logged INSERT, and Change Data Capture, with an emphasis on how they can make your life easier for querying, updating, and loading your DW.
Principal Program Manager
Eric Hanson is a Principal Program in the Core RDBMS team in SQL Server. He is the scenario coordinator for data warehousing enhancements across the SQL Server product. Prior to coming to Microsoft in 2002, he was a computer science professor specializing in database systems at the University of Florida for 10 years, and founded a database alerting software company. He received his PhD at UC Berkeley in computer science, specializing in database management systems, in 1987. He served as a US Air Force officer from 1987-1991.
Register Now for PASS Summit 2010!

  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!

Gold Sponsor

Copyright 2010 by PASS | Terms of Use | Privacy Statement