At a Tech Ed On Road session I was asked to explain multidimensional space in simple words. Here are dimension, member, value, attribute and size.
SQL SERVER – BI Quiz – Troubleshooting Cube Performance
My SQL BI Quiz question: your cube suddenly returns data very slowly. What three things would you check first when troubleshooting cube performance?
Late-Arriving Dimension Rows: Inferred Members in a Data Warehouse
Handle a late-arriving dimension with inferred members, preserve fact keys, fill attributes later, and report unresolved placeholders.
SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide
The Fast Track Data Warehouse 3.0 reference guide is out. It gives a method and real examples for balancing hardware and database setup for data warehouse loads.
SQL SERVER – Introduction to Adaptive ETL Tool – How adaptive is your ETL?
How adaptive is your ETL? When source formats change from customer to customer, one-off packages pile up. That is where an adaptive ETL tool helps.
Slowly Changing Dimensions in Plain T-SQL
Slowly changing dimensions need explicit Type 1 and Type 2 rules; use T-SQL updates and inserts with tests for history and overlap.
SQL SERVER – Fast Track Data Warehouse for SQL Server 2008
My notes from Microsoft training on Fast Track Data Warehouse reference architectures for SQL Server 2008, which scale from 4 up to 48 terabytes.