What does the Future DBA Do?

Question

What does the Future DBA Do?

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

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

Eric M Russell SSC Guru Points: 125562 More actions · Answer 1

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

Eric M Russell SSC Guru Points: 125562 More actions · Answer 2

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

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)