Data Warehousing with FastTrack and PDW [NZ 2010: DAT314]
Play Data Warehousing with FastTrack and PDW [NZ 2010: DAT314]
Microsoft recently introduced the FastTrack Data Warehouse Reference Architectures -- providing a set of balanced hardware specifications and software best practices for deploying Relational DW solutions that rely on Sequential IO patterns. The FastTrack architecture offers high query performance for large databases using cost-effective hardware configurations This talk will review the principles behind the FastTrack architectures, the best-practices for building a large data warehouse solution in the FastTrack environment, and examples from customers that have prototyped and deployed FastTrack solutions this year. We'll also discuss the coming Parallel Data Warehouse, and its positioning in relation to SQL Server and FastTrack.