Questions tagged [azure-sql-server]
The azure-sql-server tag has no usage guidance.
21
questions
-1
votes
1
answer
18
views
Not able to configure DataSync in azure sql
Trying to configure DataSync for Azure sql db with on premises SQLServer DB. Got this error.The sync database specified (sqlserver1\sql-syncmeta-prod-east-001) does not match the existing sync ...
- 69
0
votes
0
answers
14
views
Getting Deadlock in Azure SQL Server and Victim query in Microsoft Internal Query
I am getting Deadlock in Azure SQL Server
There is only 1 Victim query which "Looks like" Microsoft Internal query.
The other Query is Alter Column Statement
ALTER TABLE [SomeSchemaName].[...
- 101
0
votes
2
answers
562
views
What happens to my read-replica database in failover mode?
I have a few basic questions about Azure failover. I am new to failover. I've been reading the literature and I'm ready to give this a shot. Before I take the plunge, I'd like to have a better ...
- 339
0
votes
0
answers
51
views
Azure SQL Database :: table size query takes forever to execute
I was working with the awesome Azure SQL Database Diagnostic Information Queries created by Glenn Berry and I realized that the query number 40 takes forever to execute:
-- Get Schema names, Table ...
- 1,619
0
votes
0
answers
24
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 ...
- 1
0
votes
0
answers
68
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 ...
- 487
-4
votes
2
answers
498
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
...
- 1,619
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 ...
- 301
0
votes
1
answer
4k
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 ...
- 301
2
votes
1
answer
1k
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]
...
- 301
1
vote
2
answers
454
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: ...
- 301
1
vote
1
answer
290
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 ...
1
vote
0
answers
735
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 ...
- 11
0
votes
0
answers
113
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 ...
- 167
0
votes
1
answer
470
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 ...
- 111
-2
votes
1
answer
466
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?
- 67
0
votes
1
answer
159
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 ...
Tom Malia
2
votes
1
answer
178
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 ...
- 67
3
votes
1
answer
1k
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
...
- 67
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.
...
- 167
4
votes
1
answer
5k
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 ...
- 5,884