Duplicate Data Problem In a recent consulting engagement, a client’s product listings had a sneaky data quality issue — transient duplicates. These weren’t simple copy-paste duplicates; they were records
Read More
Continuing from where we left off in Part 1, where we discussed analyzing ETL/SSIS projects, examining configurations, and dealing with errors and warnings, we now delve deeper into optimizing
Read More
Starting as an SSIS (SQL Server Integration Services) consultant in 2008, I quickly learned that diving into unfamiliar SSIS environments is a core part of my job. Often, clients
Read More