Questions tagged [azure-sql-server]
548 questions
7
votes
3 answers
Azure SQL Database - Active Directory integrated authentication
I would like to achieve following:
Avoid SQL authentication on Azure for my production configuration and use Active Directory integrated authentication
When I go to the connection string section of Azure and copy following connection…
Jakub Holovsky
- 6,543
- 10
- 54
- 98
6
votes
1 answer
What are the constraints for the Azure Sql Server administrator login name?
I am creating it using the following terraform code:
resource "azurerm_sql_server" "instance" {
name = "${local.resource_group_name}-sql-${random_integer.sql_num.result}"
resource_group_name =…
mark
- 59,016
- 79
- 296
- 580
6
votes
1 answer
Connect to Azure SQL over VPN
I have a VPN connection to my Azure cloud. When I connect I am able to see most of my network devices such as virtual machines. However, I am not able to see Azure SQL databases. I contacted support and they explained that this is not supported and…
CodeMilian
- 1,262
- 2
- 17
- 41
6
votes
2 answers
Azure SQL Server, is it possible to disable server admin (after creation)?
Case
I want to work with Azure SQL Server, as noted in the best practices how to secure Azure SQL Server it is good to use AAD account for accessing your server/database instead of SQL Accounts.
I read several posts on the documentation site of…
Sven
- 195
- 2
- 11
6
votes
2 answers
How can I avoid a SqlClient timeout error during execution of a C# Azure Function?
I have created a function app time trigger with C#.
Inside the logic, I call and execute a stored procedure that I have created in SQL Server.
The execution of the stored proc takes more than 8 minutes, and I have got the following error in Azure…
Terry Yulianto
- 73
- 1
- 3
6
votes
1 answer
VarBinary(max) updates very slow on SQL Azure
We store some documents in a SQL Server database VarBinary(Max) column. Most documents will be a few KB, but sometimes it maybe a couple of MB.
We run into an issue when the file becomes bigger than about 4MB.
When updating the VarBinary column in a…
Christian
- 269
- 1
- 10
5
votes
5 answers
Azure SQL serveless database cpu billed constantly
So I have a bit of an issue with setting up a new Azure SQL serverless database.
I keep getting high CPU billed usage which is costing a fortune, I have resorted to even creating a new DB with a new name in a new region, with a new username and…
Altus Baard
- 151
- 1
- 11
5
votes
6 answers
How do you check the status of a SQL Import Export Operation in Azure?
I am performing a SQL Database Import using a BacPac file to Azure using the REST management API. I need to be able to check the status of an import, as Azure does not allow for me to send events when the import succeeds.
Here is the documentation…
Colin
- 624
- 8
- 27
5
votes
4 answers
How to replace a value in comma separated string column in SQL Server
I have a comma-separated value like 1,2,3,4 in one the column in a table in my SQL Server database. I want to replace a particular value in the comma separated string. i.e., from 1,2,3 I have to replace 1 with 5 and 2 with 6. The expected output is…
Aswin Sathyan
- 283
- 4
- 19
5
votes
0 answers
How to decrypt(offline) value that is protected by SQL Server AEAD_AES_256_CBC_HMAC_SHA_256
It is possible to manually decrypt value that is encrypted by sql server always encrypted mechanizm? I mean how to decrypt column value that is encrypted by AEAD_AES_256_CBC_HMAC_SHA_256 algorithm.
I have encryption key(in other topic I was asking…
sglogowski
- 321
- 3
- 12
5
votes
3 answers
How to backup Azure SQL that will withstand deletion of azure server
Azure SQL has built in backups. If the SQL database and server are deleted from within the Portal these backups are lost.
What is best practice for backing up Azure SQL that will withstand deletion of the server from the portal.
I have manually…
rollsch
- 2,518
- 4
- 39
- 65
5
votes
1 answer
What Azure role allows a user to configure SQL Server firewall rules?
What Azure role allows a user to configure SQL Server firewall rules?
Assigning the SQL Security Manager role gives me access to most of the server settings but when I click on 'Show Firewall Settings' I get the message No access on the Firewall…
David Sopko
- 5,263
- 2
- 38
- 42
4
votes
2 answers
User Assigned Managed Identity for Azure Sql Server
I'm new to Azure Cloud. I'm trying to assign user assigned managed identity to Azure Sql Server for Function App Resource. I have added User who can access Azure Sql Server. Simultaneously I had tried to turn on system identity.
What is exactly…
Early Bird
- 73
- 7
4
votes
4 answers
Aggregate multiple tables considering indexing with values derived from one table
Consider I have three tables (bet,win,cancel) that will contain the data for rounds of bets. Each round can have 1 or more bets and 1 or more wins. A round may be cancelled before any wins are recorded.
I would like to aggregate the data so that…
Fuzz
- 906
- 1
- 12
- 24
4
votes
1 answer
Unable to Query Serverless Pool View in Azure Synapse using SQL Admin Credentials
I have set up a Serverless SQL pool in Azure Synapse that is querying a view I had set up of a linked Azure Data Lake.
CREATE VIEW DeviceTelemetryView
AS SELECT corporationid, deviceid, version, Convert(datetime, dateTimestamp, 126) AS…
Josh L
- 1,412
- 2
- 18
- 40