Questions tagged [azure-sql-server]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
40 views

Azure SQL Database - What is the setting for 'cost threshold for parallelism'

In SQL server the default setting for cost threshold for parallelism is 5. I know that this setting can't be modified in Azure SQL server (as mentioned here). My question is whether Azure SQL server ...
2
votes
1answer
130 views

Azure SQL Database - Modify cost threshold for parallelism

I attempted to update the value of cost threshold for parallelism but since my database is an Azure SQL database I can't run the command: EXEC sp_configure 'cost threshold for parallelism', 40 ; GO ...
1
vote
1answer
84 views

CREATE LOGIN "MUST_CHANGE" does not work for Azure

I want to create logins for users for my Azure SQL database. Naturally I don't want to know the users' passwords so I want to set it up so that they HAVE to change their password on first login. ...
0
votes
0answers
28 views

Powershell connecting to Azure SQL DB errors out using Active Directory Password authentication

The following powershell script connects to an Azure SQL database using Active Directory Password authentication. Add-Type -Path ('C:\Program Files\PackageManagement\NuGet\Packages\Microsoft.Data....
3
votes
1answer
1k views

Azure SQL Server outdated version - how can I upgrade it to current version?

I've connected to couple of Azure SQL Servers (those are hosting few Azure SQL Databases on them) in SSMS Object Explorer and see that version is 12.0.2000.8 select @@Version shows below: Microsoft ...