Questions tagged [azure-sql-server]
548 questions
4
votes
1 answer
Spring Batch & Azure SQL Server : SQL Server did not return a response. The connection has been closed
I have a spring batch application that uses Azure SQL server, it runs without any issues and updates the Database for a most part however I am getting the following error occasionally
what does it mean? how to handle this?
Note: this is a long…
One Developer
- 99
- 5
- 43
- 103
4
votes
2 answers
Is there downtime while Scaling Azure SQL Elastic Pool Storage?
I have an Azure SQL Elastic Pool with 800 eDTUs and 400GB of Storage.
In past, I used to have 400 eDTUs, and when I scale to 800 eDTUs I had a small downtime in the website (~15-30 seconds), so before making any changes to the storage, I'd like to…
Vinicius Deschamps
- 385
- 3
- 15
4
votes
0 answers
Principal 'xyz' could not be resolved: how can I add a managed identity to Azure SQL Server when running under a Service Principal?
I want to add a managed identity (coming from an App Service) to Azure SQL Server.
I created an AAD group where a group of my team and the Service Principal is part of.
AzureSqlAdminGroup = TeamGroup + Service Principal
This AAD group is added as…
Rookian
- 19,841
- 28
- 110
- 180
4
votes
3 answers
Azure SQL back up setting in Terraform
Trying to set a parameter in Terraform file to back-up an Azure SQL server.
In AWS i can add a key like:
allocated_storage = 1000
engine_version = “13.00.4451.0.v1”
backup_window = “18:00-18:30”
backup_retention_period =…
Marvelous
- 341
- 1
- 6
- 15
4
votes
2 answers
Invoke-Sqlcmd with account that uses MFA in Azure
Anyone of you knows an option to execute a SQL command using PowerShell with Azure AD account that has MFA enabled? What is an alternative? Do I need to create a service principal for that?
I had no luck but only found this cmdlet,…
borys86
- 1,894
- 2
- 13
- 13
4
votes
3 answers
Permission Issue on Bulk Insert in Azure SQL Server
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 working in Azure SQL Server.
Error
You do not have…
Jo.........
- 190
- 1
- 3
- 13
4
votes
1 answer
How can I query multiple databases by name that reside on a Azure SQL server using SSMS?
I want to be able to run some ad-hoc queries to get some fast results. The following will return the number of rows in table foobar from two databases that have identical structures.
USE Master
GO
select count(*) from MyFirstDB.dbo.foobar;
select…
WhiskerBiscuit
- 4,795
- 8
- 62
- 100
4
votes
1 answer
Connect to Azure SQL server via AAD Authentication using EF Core
Azure SQL servers support AAD authentication, and I want my applications to connect to SQL server using AAD authentication and not SQL server admin credentials. I am using EF core to connect to SQL, how do I enable EF Core to use AAD…
Pratik Bhattacharya
- 3,596
- 2
- 32
- 60
4
votes
1 answer
SQL Azure Collation
If you were building a new database in SQL Azure, which collation would you use?
SQL_Latin_General_CP1_AS_AI or Latin_General_AS_AI?
Reason I ask is that the default collation on SQL Azure is SQL_Latin_General_CP1_AS_AI as described…
Owen
- 43
- 1
- 4
4
votes
1 answer
Configuring Azure SQL Server firewall - is allowing all IP's to connect a red flag?
I just created my first Azure SQL Server and Database and now am trying to configure the firewall so that my web application can connect and make changes to the single database on the server.
I see that you can allow all clients to connect by…
Pipeline
- 1,029
- 1
- 17
- 45
3
votes
0 answers
Getting EF Core migrations working on an Azure Sql Server using MSAL and Microsoft.Data.SqlClient (5.0)
I have a desktop app that creates a database using ef core migrations.
The app can use Postgres, Sql Server or Sqlite.
I would like to use an Azure Sql Instance, with azure ad, to hold the database. I created an
azure subscription, added an Azure…
dgxhubbard
- 703
- 2
- 7
- 18
3
votes
1 answer
Check whether EXTERNAL DATA SOURCE exist in Azure SQL
I am new to Azure SQL Database. I have a EXTERNAL DATA SOURCE as listed in following link.
CREATE EXTERNAL DATA SOURCE
CREATE EXTERNAL DATA SOURCE [My_data_src] WITH (TYPE = RDBMS, LOCATION = N'myserver', CREDENTIAL = [my_cred], DATABASE_NAME =…
LCJ
- 22,196
- 67
- 260
- 418
3
votes
2 answers
In SQL Server Profiler shows - Query Execution takes 1ms but in Spring App takes 30ms, where is the delay?
I have a simple Table created in Azure SQL Database
CREATE TABLE DeleteMe(
[ID] [int] NOT NULL,
[LastName] [char](255) NOT NULL,
[FirstName] [char](255) NOT NULL,
[Age] [int] NOT NULL,
[DOJ] [datetime2](0) NOT NULL,
[Role]…
One Developer
- 99
- 5
- 43
- 103
3
votes
1 answer
Spring Batch - HibernateItemWriter : Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port
I have a Spring Batch application that uses HibernateItemWriter to update the Azure SQL Server database.
The batch job gets executed for 20mins and failed with the following error
Could not open Hibernate Session for transaction; nested exception…
One Developer
- 99
- 5
- 43
- 103
3
votes
3 answers
Azure SQL Convert "Time zone display name" to "Time zone ID"
I am working with the latest version of Azure SQL. I have a series of Time zone display name and want to convert those into Time zone ID. I know SQL server contains both the display name and the id. sys.time_zone_info has all the Time zone ID, but…
Jeff
- 674
- 1
- 5
- 17