Synapse Azure Preview - ServerName

Martina Novakova 1 Reputation point
2020-08-27T05:33:32.277+00:00

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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,633 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 37,776 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