How to: Pause/Resume SQL Pool from Azure Data Factory

preview_player
Показать описание
In this video I show how easy is it to pause/resume/resize an Azure Synapse SQL Pool (formally Azure DW).

The Rest API page is here;

  1. Mark Pryce-Maher
  2. Pause
  3. Azure Serverless
  4. Resume
  5. resize
  6. Azure Data
Рекомендации по теме
How to pause 0:18:05

How to pause or resume Azure Synapse SQL with Azure Data Factory and Logic App

How to: Pause/Resume 0:13:14

How to: Pause/Resume SQL Pool from Azure Data Factory

Pause & Resume 0:05:41

Pause & Resume Azure Synapse Dedicated SQL Pools with Data Factory Pipelines

How to schedule 0:10:37

How to schedule Synapse/SQL pools to pause and resume using Azure automation and Powershell -Part 1

2. Pause and 0:23:51

2. Pause and resume dedicated SQL pools with Azure Synapse Pipelines

How to schedule 0:08:23

How to schedule Synapse/SQL pools to pause and resume using Azure automation and Powershell -Part 2

Pause and Resume 0:03:15

Pause and Resume Synapse Dedicated SQL Pools

Auto Pause Delay 0:09:57

Auto Pause Delay in Azure SQL Database | How to Pause Sql Database in Serverless Compute Tier

Test Screencast Pause 0:01:09

Test Screencast Pause Resume

4. Diff between 0:59:03

4. Diff between Dedicated and Serverless SQL Pool and how to automatically pause dedicated SQL Pool

Scale Dedicated Azure 0:05:01

Scale Dedicated Azure Synapse SQL Pool Dynamically

How to: Shutdown 0:10:40

How to: Shutdown Azure Synapse SQL Pool using Azure automation.

SQL Server Mirroring 0:17:01

SQL Server Mirroring 4 - Pausing and Resuming Database Mirroring and Transaction Logs

Proactive Resume and 0:12:18

Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless

Azure Synapse Analytics 0:11:38

Azure Synapse Analytics - Cost Control in Serverless SQL Pools

Can you Create 0:02:37

Can you Create Dedicated SQL Pool outside of Azure Synapse #azuresynapseanalytics #sqlpool

Azure Synapse Dedicated 0:11:44

Azure Synapse Dedicated SQL Pools

SQL Dedicated Pool 0:48:26

SQL Dedicated Pool Architecture | DP-203 | K21Academy

Azure Synapse Top 0:16:14

Azure Synapse Top Interview Questions & Answers | Azure Cloud Data Warehouse | Synapse SQL Tutor...

How to pause 0:06:38

How to pause or resume calculations in Power BI

Use a Keyword 0:07:44

Use a Keyword in Microsoft Teams with a Power Automate Flow to Resume & Pause Azure Synapse

How to scale 0:15:18

How to scale Azure Synapse SQL with Azure Data Factory and Logic App

Synapse Espresso: Distribution 0:07:25

Synapse Espresso: Distribution in Dedicated SQL Pools

Scale up or 0:00:16

Scale up or Down Azure Sql

Комментарии
Автор

Nice to know these things
Mark Pryce-Maher! Thanks for sharing these know-how things, Sharing is always Caring!

arulmouzhiezhilarasan
Автор

Excellent demo Mark, thanks for the demo

RamaKrishna-luhe
Автор

Hey Mark, I faced with an issue : AuthorizationFailed", "message":"The client 'XXX' with object id 'XXX' does not have authorization to perform action. Thoughts?

romangaleev
Автор

Great!
Do you have any solution for synapse workspace and dedicated SQL pool?
Thanks for your help!

miklosboros
Автор

Trying to do this with the ADF-built-into-synapse and not getting success. When I get to the role assignment part @ 8:56, i can't find the managed identity - nothing shows up under data factory or the other services. Is there a different process for the ADF that's BUILT IN to synapse?

sherifffruitfly
Автор

Hey Mark,
This rest api will expire? When I try to do the way you are doing.... I'm getting authentication error, even though I provided all required access

vasudevarao
Автор

Hello Sir,

How can I pause/resume azure SQL datawarehouse through automate process.
Thanks for your help in advance

amitjaju
visit shbcf.ru