SQL Server 2008 - Data Warehousing

SQL Server Developer Center > Home > Versions > SQL Server 2008 > SQL Server 2008 - Data Warehousing

SQL Server 2008 – Data Warehousing

Use the data warehousing capabilities of Microsoft SQL Server 2008 Enterprise to build faster warehouses, manage growing data volumes, integrate with Microsoft business intelligence products, and with the recent acquisition of DATAllegro, scale a warehouse to perform across hundreds of terabytes of data.

Get Started

Product Overview:	SQL Server 2008 Data Warehousing \| Project Codename “Madison”

Books Online Topics:	AdventureWorks Sample Data Warehouse \| Data Warehousing and Reporting

Video:	SQL Server 2008 Data Warehousing \| SQL Server Fast Track Data Warehouse by Mark Theissen

Other Resources:	SQL Server Fast Track Data Warehouse \| Webcast: Early Look at Madison and Kilimanjaro \| Data Warehousing Blog

Technical Articles

	Partitioned Table and Index Strategies Using SQL Server 2008
	Introduction to New Data Warehouse Scalability Features in SQL Server 2008
	Scaling Up Your Data Warehouse with SQL Server 2008
	Best Practices for Data Warehousing with SQL Server 2008
	SQL Server 2008 Data Warehouse Query Performance
	Business Intelligence and Data Warehousing in SQL Server 2005
	Data Warehouse Query Performance

Community Buzz

	SQL Server Data Warehousing Forum
	Discussions in SQL Server Data Warehouse
	SQL Server Data Platform Insider news blog: posts on Data Warehousing

Webcasts

An Early look at SQL Server ‘Kilimanjaro’ and project codenamed ‘Madison’ (level 100)
TechNet Webcast: 24 Hours of SQL Server 2008: Data Warehousing Management (Level 200)
TechNet Webcast: 24 Hours of SQL Server 2008: Data Warehousing Scale and Performance (Level 200)
TechNet Webcast: Data Warehousing Enhancements in Microsoft SQL Server 2008 (Level 200)

Enterprise DW Architectures

	Introduction to Fast Track Architectures
	Implementing a SQL Server Fast Track Data Warehouse
	Using SQL Server To Build A Hub-and-Spoke Enterprise Data Warehouse Architecture
	Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

Top 10 Lists

MVP Corner

Alejandro Leguizamo has been working with SQL Server since 6.5, and with MS Access since Office 97. His core area is Data warehousing and Business Intelligence, plus ETL.