Archive | Reporting RSS feed for this archive

T-SQL Tuesday #005: Cleanup Your Notification Emails With HTML Tables

Clean-up your email notifications with simple HTML tables. Easy to use, why sent plain text?Post (along with a poll) for #TSQL2sDAY

4 Comments Continue Reading →

Data Quality -Dynamic Business Validation

Table driven, dynamic validations to find post-load data issues.

Leave a Comment Continue Reading →

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, […]

Leave a Comment Continue Reading →