Questions tagged [azure-sql-server]
548 questions
1
vote
1 answer
Can an Azure SQL server be unavailable / unreachable for a period of time after creation?
I am creating an Azure SQL server & db via a terraform task within an Azure Devops Pipeline using hosted agents.
The resources create without issue.
However, the next job in my stage tries to run a db_init.sql script against the newly created db…
Killian
- 414
- 2
- 10
1
vote
1 answer
Get-AzureRmSqlServerAuditing: The term 'Get-AzSqlServerAuditing' is not recognized as a name of a cmdlet, function, script file
I want to check the auditing status of the SQL server using the Azure CLI command.
I have SQL Server named 'dummy-sql' inside resource group 'group1'.
So According to this…
Yogesh
- 155
- 1
- 9
1
vote
1 answer
Logs of executed Query in SQL Server
Database having 5 users
All users are running queries on database
we need to find what are the things all users doing like (Query , session_id,starttime , endtime,Database name,username , hostname )
we need to insert all the data into one…
konda masthanreddy
- 39
- 1
- 8
1
vote
1 answer
accept parameters from sql table in adf pipeline
I have a request to select the values from a sql table and pass it to adf pipeline
example:
sql table-->abc with columns(col1,col2,col3,col4,col5)
I need to pass the col1 to col5 values as input to a pipeline abc.
how can we do that please suggest…
batman_special
- 115
- 1
- 2
- 10
1
vote
1 answer
Azure SQL - would Geo-replication cause any performance impact?
I have an Azure SQL in WEST US and I want to setup the failover grop with EAST US.
would Azure SQL Geo-replication/failover group cause any performance impact? If so, what would be the impact?
One Developer
- 99
- 5
- 43
- 103
1
vote
1 answer
How to connect to a remote MySQL from an Azure SQL server/database
sorry if title is not so clear, probably I am not finding what I need due I do not know how to search
I have few MySQL servers is separated online servers (from different wordpress) and I want to load some of the data on those databases/tablets into…
CarlsWhishde
- 13
- 3
1
vote
1 answer
Is there a way to disable and re enable FOREIGN KEY constraints for a database Azure SQL
I'm trying to truncate some tables in a database. Some of these tables have foreign keys. So when I try to truncate them I get the following error.
Cannot truncate table 'IDN_OAUTH2_ACCESS_TOKEN' because it is being
referenced by a FOREIGN KEY…
Buddhima Udaranga
- 943
- 7
- 10
1
vote
1 answer
Get CPU used (Max) and CPU used (Avg) in Azure SQL Elastic Pool
I want to get get "CPU used (Max)" and "CPU used (Avg)" from the Portal using a SQL Query or Powershell script. I used "sys.elastic_pool_resource_stats", but did not mentioned details.
Is there any way to do this, using SQL Query.
Below is the…
Baxy
- 139
- 1
- 13
1
vote
1 answer
Creating User managed identity and server administrator using ARM Template
I want to add a user managed identity as admin to a sql server resource in azure. I can create the user identity using ARM Templates like this:
{
"type": "Microsoft.ManagedIdentity/userAssignedIdentities",
"name":…
Ashish Kumar
- 83
- 9
1
vote
1 answer
Whitelist the outbound IP address of an Azure Web App in the Azure SQL server firewall settings using ARM templates
I want to whitelist the outbound IP address of my Azure Web App in the firewall settings of the Azure sql server using Arm templates.
However, I do not want to hardcode the start and end Ip addresses in the ARM template.
Is there a way of…
SD4
- 439
- 10
- 27
1
vote
1 answer
Database Table Constraint using LIKE operator
I am trying to setup constraints on my database table using like operator. Is this possible in Azure SQL Server?
I have a column FILE_NAME that has for example 'VID' as a common pattern in most of the records. Then, I have another column FILE_TYPE…
Julaayi
- 403
- 2
- 8
- 23
1
vote
1 answer
How calculate two geo distance (Latitude,Logitude,Altidute) points in Azure Sql server?
How do I get an accurate distance (in meters) given two geo-points (two latitude/longitude/Altitude pair) in Azure Sql server?
Latitude Longitude Altitude
22.30634 113.92934 125
Latitude Longitude Altitude
58.31962 -157.54788 …
Codehunter
- 69
- 5
1
vote
1 answer
Azure SQL Server "clr strict security" can this be changed
I'm trying to change the 'clr strict security' in Azure SQL Server, but not able, is this no more possible in Azure Managed SQL Server.
I've created a certificate first and then I tried to create a login for the certificate and thats failing as…
Abhishek
- 23
- 6
1
vote
1 answer
T-SQL Query errors when using TOP ()- but not when pulling the full query
We have a View in Azure SQL server that is erroring - but only when utilizing TOP.
SELECT * FROM View = fine.
SELECT [list every column individually] FROM View = fine
Take the underling code from the View and run it = fine.
It's just including TOP…
bbb0777
- 165
- 14
1
vote
2 answers
See history of sql statements run by user in Azure SQL
Is there a way to see a list of statements run by a specific user in Azure SQL? I have a user that complains about query performance. The queries are generated by a tool so he doesn't know the actual query text.
If I look in Azure Portal on that…
johanrex
- 389
- 5
- 18