azure-sql-server Questions
3
Solved
I'm facing this issue intermittently now, where the query (called from stored Procedure) goes for CXSYNC_PORT wait type and continues to remain in that for longer time (sometimes 8hours in stretch)...
Microspore asked 24/12, 2020 at 11:2
2
I'm experimenting with the Serverless tier in Azure SQL, but the database never "sleeps" because it seems that Azure is continually querying the database behind the scenes. I created the database v...
Cigarette asked 12/9, 2019 at 15:8
6
Solved
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 n...
Stringboard asked 21/12, 2020 at 8:53
2
Solved
I want to move my azure sql db to another host. However my new host allows to import sql db backup-files (.BAK) only;
I found out how to generate .BACPAK files with SQL Server Management Studio bu...
Putout asked 17/4, 2017 at 7:47
1
I have Azure DevOpe pipeline, which have worked fine so fine, but yesterday I got suddenly showstopper error. Pipeline gave no error, but SQL Logical Server was not created.
I deleted all resources...
Popple asked 29/7, 2020 at 10:20
3
Solved
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 ...
Gabler asked 11/4, 2018 at 9:45
2
We are in the process of moving to Azure SQL Server from Oracle DB for our Spring Batch application.
I am getting the following error while trying to execute two different jobs at the same time tha...
Deaminate asked 3/1, 2022 at 9:15
4
Solved
I have an Azure Web App and an Azure SQL Server, both in the same subscription. Both of them are connected to the same VNet Subnet as shown in the below snapshots. The SQL Server is configured not ...
Keele asked 9/6, 2020 at 6:34
6
Solved
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 w...
Muth asked 20/6, 2019 at 19:8
2
Solved
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.
...
Sub asked 19/7, 2018 at 21:10
1
In the following code of my WPF Core client app , I am trying to use this Azure SQL Database REST API to delete a database in my Azure subscription. But I am getting the error shown below:
Question...
Sula asked 10/10, 2020 at 4:24
2
Solved
whenever i try to import BACPAC on local sql server I am getting below error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Could not import package.
Warnin...
Genoa asked 10/11, 2017 at 0:31
5
Solved
I am having pay as you go subscription and I am creating an Azure SQL server.
While adding server, on selection of location, I am getting this error:
This location is not available for subscripti...
Jerz asked 21/3, 2020 at 17:12
2
Solved
I have configured an EventGrid subscription to initiate a web hook call for events in a resource group when a resource is created.
The web hook call is successfully handled, and I return a 200 OK....
Arc asked 19/12, 2018 at 13:6
3
Solved
User is getting below error while running bulk insert command in Azure SQL Server. I am using Azure SQL Server and not SQL Sever. Most of the commands related to Bulk Insert grant permission is not...
Tolan asked 22/2, 2019 at 22:31
1
Solved
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 = l...
Sarcocarp asked 27/1, 2020 at 3:59
4
Solved
In on premise SQL databases, it is normal to have a maintenance plan for rebuilding the indexes once in a while, when it is not being used that much.
How can I set it up in Azure SQL DB?
P.S: I t...
Quincyquindecagon asked 8/2, 2018 at 8:38
2
Solved
I have created my Azure SQL server through ARM templates. To enable the vulnerability assessment I need to enable Advanced data security.
I use the following code in my ARM template inside the reso...
Hesperidium asked 16/7, 2019 at 11:59
1
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 suppor...
Argil asked 6/8, 2019 at 13:15
1
Solved
As part of an Azure SQL database automation solution, I'm trying to create Azure SQL database users mapped to Azure AD Identities, using a service principal.
The result is an error message saying:...
Winding asked 26/10, 2018 at 5:16
1
Solved
We are moving from Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
to
Microsoft SQL Azure (RTM) - 12.0.2000.8
Previously we send mail from database mail if a particular table have not updat...
Disenthrall asked 20/2, 2019 at 9:29
1
Solved
We have an Azure SQL server. From some machines in our Azure subscription we cannot connect to our SQL server, but from other machines it's fine. From machines outside of Azure we have no issues at...
Coeternity asked 21/11, 2018 at 6:40
1
Solved
We have an Azure SQL database. Up until a few weeks ago, we were set at 10 DTUs (S0). Recently, we've gotten more SQL timeout errors, prompting us to increase our DTUs to 50 (S2). We get the errors...
Phenobarbitone asked 29/6, 2018 at 21:9
2
Solved
Is it possible to assign an Active Directory Administrator to an Azure SQL Instance within an ARM resource template? I'm trying to automate the deployment of a database server, but I only seem to b...
Grade asked 3/10, 2016 at 20:0
2
Solved
I'm trying to add an Azure SQL Server connection string into my app.config file, but there are red underlines all over the connection string when I try to copy and paste it from Azure. I'm using Wi...
Woodworm asked 2/8, 2017 at 4:49
1 Next >
© 2022 - 2024 — McMap. All rights reserved.