Table driven, dynamic validations to find post-load data issues.
Archive | 2010
Database Driven Aggregations
Introduction Have you ever had a series of aggregate (tsql) queries to run? Do you want to be sure they all run in the right order? Do you want to make the changes “dynamic” (no code changes required)? Certainly you can build an SSIS package that calls sql with the control-flow and control dependencies, however, […]
Help – My disk performance VI
Part VI in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers additional monitoring, and wraps ups some leftovers from this series.
Help – My disk performance V
Part V in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers basic monitoring.
Help — My disk performance IV
Part IV in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database filegroups and files.
Help – My disk performance III
Part III in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database partitioning and compression.
Help – My disk performance II
Part II in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers physical connection, and LUN layout on a SAN.
Help – My disk performance
Part I in a series of discussions about Data Warehouse disk configuration, monitoring, and performance.
StefBauer's Blog - @StefBauer 