Blog
Remove Double Quotes in Microsoft SSIS
There are different ways to modify strings in a SQL Server Integration Services (SSIS) process. You could modify the strings as they are read from SQL Server by using SQL …
SalesForce NULL errors in SQL Server
If you are reading SalesForce data into SQL Server through a linked server you might encounter null data errors that look like this: An unexpected NULL value was returned for …
Data Quality: Putting it all together
My concluding chapter on the data quality dimensions.
Cognos Analytics Dashboard Scroll Problem
In Cognos Analytics 11 (in either 11.0.x or 11.1.x) you may discover that you have what I like to call the “Cognos Analytics Dashboard scroll problem”. This is when you …
Data Quality: Reasonability
My latest on data quality, the data quality dimension of reasonability.
Pandemic Stock Market: What, me worry?
Checking in on my Tableau visualization and following the markets in general, we see an unprecedented recovery rally in the face of economic turmoil and gathering pandemic devastation in the …