Tag: Expressions

SQL

Retrofitting Schemas with Computed Columns

Post author By Andy B.
Post date Aug 4, 2026
2 Comments on Retrofitting Schemas with Computed Columns

Computed columns allow us to bake logic into our schema. I find particular use for these when reviewing or optimising established solutions where you spot the quirky ways the data is being used. Here I want to demonstrate 3 symptoms and show how different implementations of computed columns solve them. Baking the expression Common expressions […]

Tags Computed Columns, Expressions, Hashing, Optimisation, Performance, Persisted, Querying, Tuning

SSIS

Case Sensitivity in Integration Services

Post author By Andy B.
Post date Jan 28, 2025
1 Comment on Case Sensitivity in Integration Services

Case sensitivity in data can trip us up unknowingly and Integration Services is no exception. Depending on the components we’re using we may notice different behaviour. Without understanding the way case sensitivity is treated within SSIS packages, we may see unexpected results with string comparisons. Let’s clear things up and dive into a few examples […]

Tags Case Sensitivity, Character Map Transformation, Collation, Expressions, Integration Services, Lookup Transformation, SSIS