A Pattern for Error Handling in T-SQL Stored Procedures

SQL Server MVP Erland Sommarskog has written a staggeringly detailed and thorough series of articles on error handling in T-SQL.

In the first of these articles Erland presents a pattern for error handling that he suggests is suitable for 90-95% of coding situations, and that works for SQL Server […] “A Pattern for Error Handling in T-SQL Stored Procedures”

Using SQL Server’s Parameter Embedding Optimisation

In this post I’m taking a look at the Parameter Embedding Optimisation that can be used by the SQL Server query optimiser when statement level recompilation is used.

This can be taken advantage of, for example, when implementing dynamic filtering or dynamic sorting, i.e. when user input determines which columns of a table […] “Using SQL Server’s Parameter Embedding Optimisation”

Finding the Column Name of an SSIS Error Output Error Column ID

Many SSIS data flow components have error outputs for optionally directing rows through, e.g. for handling data type conversion errors.

These error outputs include the data columns being handled by the component, as well as 2 additional columns – an ErrorCode column and an ErrorColumn […] “Finding the Column Name of an SSIS Error Output Error Column ID”