Once in a while my colleagues ask me to change a jpeg image stored in a databaserecord, and every single time they ask I need to search all my sql files to find the query needed to do this. Maybe I’m not the only one who needs this, that’s why I’m posting my solution here… […]
You are browsing archives for
Tag: SQL
SSIS Lookup component is case sensitiv
The other day, i was working on a new SSIS (SQL Server Integration Services) package to transform data from a production database to an analysis database. It worked quite well, i thought, everything seemed to work as it was supposed to when testing with a subset of data. So next up, live usage. And that […]