Synapse Azure Preview - ServerName

Martina Novakova 1

Hi,

I am trying to pause SQL pool in Synapse (Preview version) via PowerShell command and Automation.
I've found this: Suspend-AzureRmSqlDatabase –ResourceGroupName "myResourceGroup"
–ServerName "nsqlpoolservername" –DatabaseName "mySampleDataWarehouse"`
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/pause-and-resume-compute-powershell

But there is an error - it can't find ServerName (I though that server should be the name of Workspace).
When I try to get all servers in my resource group - it says there is nothing (but there is still Synapse Worskapce and SQL pool in this Workspace).
Could you please let me know if there is any other command how to pause Sql pool or what should be really the name of ServerName (if the name of Workspace doesn't work)?
Thank you
M.

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-02T06:44:24.023+00:00

Hi @Martina Novakova ,

We have not received a response from you. Please suggest if below answer from @Vaibhav Chaudhari helped to clarify the question. Kindly let us know for further queries and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,136 Reputation points

2020-09-03T04:43:55.337+00:00

Hi @Martina Novakova ,

We still have not heard back from you. Following up to check if below answer from @Vaibhav Chaudhari helped to clarify the question. Kindly let us know for further queries and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

1 answer

Vaibhav Chaudhari 38,631 Reputation points

2020-08-27T05:44:59.767+00:00
Could you try below one that I found here - update-azsynapsesqlpool

Give -Name value as your SQL pool name

Update-AzSynapseSqlPool [-ResourceGroupName <String>] -WorkspaceName <String> -Name <String> [-Suspend] [-PassThru] [-AsJob] [-DefaultProfile <IAzureContextContainer>] [-WhatIf] [-Confirm] [<CommonParameters>]

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Please sign in to rate this answer.

1 person found this answer helpful.
Martina Novakova 1 Reputation point

2020-08-28T04:47:09.93+00:00

Hi, I am still using AzureRm instead of Az. Is there similar command for AzureRm?Thank you

Vaibhav Chaudhari 38,631 Reputation points

2020-08-28T05:09:38.837+00:00

Sorry, not aware of similar cmd for AzureRm.

Az module is the latest and only this will have the latest features updates mostly. You can try to run the Az command in Azure portal browser as well if you don't want to uninstall AzureRm

Reference - https://learn.microsoft.com/en-us/powershell/azure/new-azureps-module-az?view=azps-4.6.0#upgrade-to-az

HarithaMaddi-MSFT 10,136 Reputation points

2020-08-31T08:02:58.26+00:00

Hi @Martina Novakova ,

Thanks for posting the query.

As per MS documentation, AzureRM will no longer receive new cmdlets or features. However, the AzureRM module is still officially maintained and will get bug fixes through December 2020. Link provided by @Vaibhav Chaudhari helps in alternative way of running these commands.

Hope this helps! Please let us know for further queries and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Sign in to comment