What does the Future DBA Do?

  • That sounds like workflow - you can move files around in Blob Storage using Azure Data Factory, REST API, PowerShell, etc.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • The following article is an overview of how Azure Function can be spun up to bulk load .csv files in parallel from Blob Storage to Azure SQL, how Blob Triggers can respong to events, exporting from Azure SQL to Blob Storage, etc.

    https://marczak.io/posts/azure-loading-csv-to-sql/

    I think you'll like Azure Functions, because they allow you to spin up X number of micro containers for executing C#, Python, PowerShell, etc. scripts using CPU resources outside your Azure SQL database.

     

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Cool.  Thanks Eric.  I'll take a look.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply