Find all references to following image locations & update to assets.andrewconnell.com:
[ ] Flickr
[ ] aciassets.blob.core.windows.net
[ ] /blobcontent
Script to do it...
UPDATE [dbo].[cms_Common_BodyPartRecord]
SET [Text] = REPLACE([Text],'http://aciassets.blob.core.windows.net/', 'http://assets.andrewconnell.com/')
WHERE [TEXT] LIKE '%aciassets.blob.core.windows.net%'
Find all references to following image locations & update to
assets.andrewconnell.com
:aciassets.blob.core.windows.net
/blobcontent
Script to do it...