Questions tagged [azure-sql-server]
548 questions
1
vote
1 answer
Having trouble creating an azure sql database dependency for my project
I am getting the following errors when I try to create the azure sql dependency:
Microsoft.WebTools.Shared.Exceptions.WebToolsException:
Unsupported resourceID…
MikeWizowski
- 11
- 1
1
vote
1 answer
Spring Batch: Hibernate print SQL queries and time taken
I have a spring batch application that uses Azure SQL server as a backend, I am using Hibernate to update the database.
Below is my Hibernate configuration
One Developer
- 99
- 5
- 43
- 103
1
vote
0 answers
Hibernate Performance is slow: Spring batch & Azure SQL Server
I have a spring batch application that uses Azure SQL server as a backend, I am using Hibernate to update the database.
I am reading the data from CSV file using FlatfileReader & writing into Azure SQL Server using ItemWriter as mentioned…
One Developer
- 99
- 5
- 43
- 103
1
vote
1 answer
Is it possible to connect to an Azure Sql Database from Sql Server Management Studio with service principal/app registration?
I have configured my sql server with an Azure Active Directory admin that is a service principal (app registration). Is it possible to use clientid/secret to connect from Sql Management Studio?
I have tried Azure Active Directory - password…
Ilya Chernomordik
- 27,817
- 27
- 121
- 207
1
vote
1 answer
What is the minimum required access level (permission) required to move, create, remove Azure SQL elastic pool?
I am developing a background worker that moves database between pools, create a pool, delete a pool, etc. I couldn't find in Microsoft document what the minimum required access to do such tasks? Admin to Azure SQL Server, Contributor or anything? I…
Dan Hunex
- 5,172
- 2
- 27
- 38
1
vote
2 answers
Azure SQL Server Login/User Roles to Up and Downscale DB
Client has an Azure SQL Server with a SQL Database that is currently Standard Edition S1.
This is fine considering the database is mostly in idle mode, and data is sync'd to it once a day and extracted from it once a day.
However considering the…
LordRofticus
- 181
- 1
- 2
- 13
1
vote
1 answer
How to configure AKS deployment to make an ASP.NET app able to connect to an Azure SQL database
I have a .NET 5.0 App that connects to a SQL Server database. If I host the App in Azure App service and the database in Azure SQL database, all is fine.
Now I put the App in a Docker container and deploy it in AKS. It doesn't work anymore (can't…
Franco Tiveron
- 2,364
- 18
- 34
1
vote
1 answer
I want to extract a XML value for a matching tag stored as varchar(max) in MS Azure Synapse
I am new Azure was using SAS before now we are moving to azure synapse
In current environment
I want to extract a XML tag value stored in column C (varcharmax) as variable.
[Dataset][1]
[1]: https://i.stack.imgur.com/tbSIF.png
Below XML is saved in…
user2703679
- 35
- 2
- 10
1
vote
2 answers
Increase Azure SQL Server PITR to 35 days with ARM template
I have a ARM template like below which creates a SQL server.
{
"name": "Name",
"type": "Microsoft.Sql/servers",
"apiVersion": "2014-04-01",
"location": "EastUS2",
"properties": {
…
Damitha
- 391
- 3
- 16
1
vote
1 answer
Azure SQL - External Data Source over private endpoint
I have two databases on the same Azure SQL server. I wanted to create an external table in database A to access one table from database B. To do it I followed this this article and everything works fine. Then to increase security I wanted to disable…
rakiop
- 41
- 4
1
vote
1 answer
Find Azure SQL Database Geo-Replication Secondaries via PowerShell
I created an Azure SQL Database and configured geo-replication to a second server in a different region. In the Azure Portal, I can click on either of the databases, and see details about the regions being replicated to:
I want to use PowerShell to…
MaddHatter
- 212
- 2
- 10
1
vote
2 answers
Running a SQL select statement on every database on my Azure Server
I want to run a select statement on every database hosted on my Azure instance. I have tried the below approach but I'm getting this error:
Msg 40508, Level 16, State 1, Line 21
USE statement is not supported to switch between databases. Use a new…
user4093045
1
vote
2 answers
Azure Devops - Manage, Run and Track one-time Sql Scripts
We have a database project that uses a dacpac to deploy schema changes and also allows a pre-deployment and post-deployment script.
However, we frequently have to run one-off scripts and security would prefer that developers not have write access in…
Josh
- 16,286
- 25
- 113
- 158
1
vote
1 answer
How can I run multiple instances of a SQL Server stored procedure in parallel
I need to run a stored procedure with different parameters each time - there is no data overlap but some temp tables are being created and dropped inside the procedure.
I am calling it via ADF stored procedure activity which is being called in a for…
user12823830
1
vote
1 answer
What is the best way to change the tier of an Azure SQL Database when allocated space prevents you from doing so?
Our database recently had gotten too full and we needed to remove some data. When we tried to do so, we got an error about the size quota as follows:
Msg 40544, Level 17, State 12, Line 1
The database '' has reached its size quota.…
Cameron Jones
- 45
- 2