2020 Fix — Playing With Flour

Random articles from a puzzled DBA

2020 Fix — Playing With Flour

(e.g., the yeast shortage, viral TikTok recipes)

If 2020 had a mascot, it was the sourdough starter. Millions of people began nurturing fermented jars of flour and water, treating them like household pets. playing with flour 2020

In a year defined by loss and stillness, playing with flour was our way of proving we were still alive, still hungry, and still capable of making something good out of a mess. the yeast shortage

The story always ended the same way. The oven timer dinged. The smell of warm yeast filled the house, chasing away the smell of bleach and hand sanitizer. The bread came out, perhaps slightly burnt on the bottom, perhaps a little dense. perhaps slightly burnt on the bottom

6 thoughts on “Saving and Extracting BLOB Data – Basic Examples

  1. Jill Goodman's avatar Jill Goodman says:

    Thanks to this response – I’ve solved an outstanding problem. I’m using powershell to export the blobs, one at a time. Thanks for these examples, they were excellent.

  2. Megan Haynes's avatar Megan Haynes says:

    I am not sure what is happening but the text on this page gets bigger and bigger until you can’t see what is written. Please help

    1. Steve Hall's avatar Steve Hall says:

      I’m away from a decent connection for the next couple of days. I’ll have a look as soon as I can. WordPress changed all kinds of things a while ago and some of my older articles aren’t quite as they were.

  3. Lee's avatar Lee says:

    Thank you for the code samples, I had two tweaks that gave me a 10 fold increase:
    # Looping through records
    While ($rd.Read())
    {
    Write-Output (“Exporting: {0}” -f $rd.GetString(0));

    $fs = [System.IO.File]::OpenWrite(($Dest + $rd.GetString(0)))
    $rd.GetStream(1).CopyTo($fs)
    $fs.Close()
    }

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.