A Microsoft white paper on scale-out querying for SQL Server 2005 Analysis Services using SAN snapshots, which improves disk use and cube processing.
SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management
How NASDAQ moved its market data system from mainframes to SQL Server 2005, handling about 5,000 transactions per second at market open.
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
My Data Warehousing interview questions and answers complete list, with links to every part of the series and one PDF to download.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
Data Warehousing Interview Questions and Answers Part 3 explains slowly changing dimensions: SCD1, SCD2, SCD3 and hybrid SCD, and what each one keeps.
SQL SERVER – Data Warehousing Interview Questions and Answers Part 2
Data Warehousing Interview Questions and Answers Part 2: normalization forms, fact and dimension table keys, data mining, view vs materialized view and ER diagrams.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
Part 1 of my Data Warehousing interview questions and answers, starting with the basics: what a data warehouse is and how it supports decision making.
SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
The start of my Data Warehousing Interview Questions and Answers series, beginning with the basics: what is data warehousing and why companies use it.