Software
Assessment
Get a baseline for your
existing software and process
Ryan is a Senior Business Intelligence Developer with an emphasis on Database Administration and SQL Managed Services.
03/13/20
One particularly tedious task that folks developing ETL operations in T-SQL face at least once in their careers is the task of scrubbing textual data of unwanted – and sometimes non-displayable – characters. Somehow these special characters that cannot be displayed end up in the data; few know how or why and obviously they cannot be seen so we find out about them when some process chokes in the dead of night on a weekend because the antiquated “BEL” character somehow showed up in the data.