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

1 Comment • Continue Reading →