Rick Strahl posted this excellent article on
pre-authenticating HTTP requests - this is something that’s caught me in the past but he explains
the whole concept so well here I thought this was worth noting for my own future reference.
I’m working on a development database with a lot of varbinary fields - these are great once you have your admin screens but they’re a pain in the initial development phase when there is no GUI for loading data. This little T-SQL snippet can be used to update varbinary fields...