csharpfritz / Fritz.LiveStream

Comments, Questions, and Schedule for upcoming streams
GNU General Public License v3.0
85 stars 15 forks source link

Azure SQL Managed Instance #97

Open ngruson opened 1 year ago

ngruson commented 1 year ago

Stream Details

Date of Stream (if related)

Mar 30, 2023

Time Index(es)

Helps narrow down where/when in the stream this feedback relates

Feedback

Provide details and input about your suggestion

Hi Jeff,

In the stream, you were talking about options to run a stored procedure on a schedule (the Azure way). Although it's true that Azure SQL doesn't have SQL jobs (publicly), Azure SQL Managed Instance does. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql

I didn't hear you mention it, so just throwing this in there. There are implications ofc. It will affect your Azure bill for sure, Azure SQL is cheaper. Also, it may not be worth your while just for this feature. On the other hand, it may open up some doors for other database management tasks as well.

Keep up the Twitch streamz, really enjoy those. I'm mostly watching those post facto while working.