Questions tagged [azure-sql-server]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

Azure SQL Can't Connect to DB through SSMS Though User Can Log Into Different DB on The Same Server

I have a SQL Server on Azure with two databases which I can see just fine with the admin account Now using a regular user account I need to specify the DB i want to connect on the configuration ...
efx's user avatar
  • 1
0 votes
0 answers
54 views

Using dbatools powershell module with azure automation hybird worker groups

We want to use dbatools powershell module with azure automation . We already have dbatools module on hybird worker group machines . We tested the code we want to run by directly logging into the ...
yegnasew's user avatar
  • 487
-4 votes
2 answers
278 views

Calculate total_worker_time in minutes [closed]

I have an easy query which can show me the top 10 elapsed time by query_plan_hash and query_hash: PRINT '-- top 10 elapsed time by query_plan_hash and query_hash --' SELECT TOP 10 query_plan_hash ...
Francesco Mantovani's user avatar
0 votes
1 answer
2k views

How to set Password Expiration Date in SQL Server

As shown in the screenshot below, we don't see an option to set password expiration date. Question: How can we set a password expiration date of an existing login using SSMS or t-sql. We are using ...
nam's user avatar
  • 291
0 votes
1 answer
3k views

GRANT ALTER to role vs. GRANT ALTER ON SCHEMA

Suppose you create a user defined database role as follows: CREATE ROLE TestRole AUTHORIZATION dbo Question: Which of the following two permissions are more restrictive? Or, do the both statements ...
nam's user avatar
  • 291
2 votes
1 answer
912 views

How to add Azure AD user to a Database role

Question: What may be a cause of the error shown below. The user running the code below is a member of db_securityadmin database role: ALTER SERVER ROLE db_ddladmin ADD MEMBER [myDomainName.com\Juan] ...
nam's user avatar
  • 291
1 vote
2 answers
394 views

SQL Server tempdb files growth increment size

In our Azure SQL Managed Instance, we have 12 tempdb data files each of size 11GB. The Log file growth value is set to a max default size of 2TB. The growth value of each data file is 32GB. Question: ...
nam's user avatar
  • 291
1 vote
1 answer
248 views

Prevention of Data loss when switching from Primary to secondary database in Azure SQL during failover test

During the failover test in azure database from Primary to secondary. I see that everytime there is a loss of 3 seconds worth data during the switch. I want to minimise this data loss. The azure ...
Sajit Gangadharan's user avatar
1 vote
0 answers
676 views

Azure SQL Server grant read only access to all databases, including those created later

There is one Azure SQL Server which has 100+ databases. For auditing purposes a login is needed, that can read data (do SELECT) from all the database tables in that Azure SQL Server. Databases are ...
Kaarlo Räihä's user avatar
0 votes
0 answers
97 views

BACKUP LOG failed to write to Azure Blob

We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below ...
sydney's user avatar
  • 157
0 votes
1 answer
414 views

Can we delete data using SQL job and insert data into the same table at the same time from another application

I have created one SQL job and it is executing a stored procedure to delete data from the table at a specific time. But at the same time, if anyone will try to insert a record in that same table from ...
Explorer's user avatar
  • 111
-2 votes
1 answer
419 views

Azure SQL Server automatic tuning - Drop index

If I allow Azure to automatically drop indexes, will they only drop indexes that they auto-created or even on ones that I created?
Moshe's user avatar
  • 57
0 votes
1 answer
131 views

Can you mix on premisses SQL Servers and Azure SQL Servers in a trust group?

I need to be able to create cross-server views which include tables from databases on SQL Servers in a local corporate domain and joining to tables in a database on a hosted Azure SQL Server instance ...
user avatar
2 votes
1 answer
161 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 ...
Moshe's user avatar
  • 57
2 votes
1 answer
983 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 ...
Moshe's user avatar
  • 57
2 votes
1 answer
1k 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. ...
Tessaract's user avatar
  • 167
4 votes
1 answer
4k 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 ...
Aleksey Vitsko's user avatar