Azure SQL databases ALL go online when connecting to server

Question

Hi all,

We have setup approx. 20 Azure SQL databases (serverless with 1 hour on auto-pause).

Issue:
When we make a connection with SSMS or Azure Data Studio with a server and a specified database, then only the specified database resumes and goes online again.
However, when someone connects to the server, WITHOUT specifying a database name, ALL databases resume and go online.

Is there a way that we are able to connect to the server, without specifying a databasename, and NOT resuming all paused databases?

The reason we want to see the list of databases below a server connection is because we need this when we want import/export data with tooling (like data migration assistant).

thanks in advance,
Mark

Answer 1

Azure Data Studio 1.41 was released today. I see this in the Release notes:

I hope this clears up Mark's issue.

Answer 2

Try using PowerShell instead or CLI to list the databases. With dbatools you can do a lot of great things with PowerShell.

$servers = Get-AzSqlServer  
foreach($server in $servers){  
    Get-AzSqlDatabase -ServerName $server.ServerName -ResourceGroupName $server.ResourceGroupName | Where-Object {$_.DatabaseName -like 'jos*'}  
}  

SSMS v18.1 or earlier were auto-resume databases when a new query Windows was opened. Latest versions of SSMS do not do that. Try SSMS 19 preview or SSMS 18.12 to have a better experience with Azure SQL Serverless.

Can your users consider to use Azure Data Studio? Try this tool instead.