A brief introduction to DW 2.0 and how SQL Server handles large sets of data, including the move from data marts to a full data warehouse.
Where a Self-Service Report Actually Gets Its Data
Trace self-service BI numbers through source data, transformations, refresh schedules, credentials, gateways, and the owner of each step.
SQL SERVER – Few Notes on Fast Track Data Warehouse
My notes from teaching Fast Track Data Warehouse: the 48 TB limit, hardware vendors, the SQL Server 2008 R2 base, and terms like FTRA, SMP and PDW.
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.
Where Reference Data Should Live
Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
Data Mining Algorithms (Analysis Services – Data Mining)
I quite often receive requests for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.
SQLAuthority News – Migrating DTS Packages to Integration Services
Migrating DTS packages to Integration Services? Brian Knight’s white paper covers two proven methods, and I add tips on testing the result.