5,667 questions with Azure SQL Database tags

Sort by: Updated
Updated Created Answers
1 answer

Unable to create sql server db

Hello All, When I'm trying to create a sql server db using a free acount it says "Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to…

Azure SQL Database
asked 2024-10-03T16:45:22.91+00:00
Anil Kumar Pant 0 Reputation points
edited the question 2024-10-03T21:50:31.6933333+00:00
VarunTha 8,135 Reputation points Microsoft Vendor
1 answer

Please suggest a way to replicate or transfer data from azure sql database to fabric lakehouse in realtime

Need to transfer large amount of data from azure sql database to fabric lakehouse in relatime.

Azure SQL Database
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
43 questions
asked 2024-10-03T19:00:08.4266667+00:00
AGP 20 Reputation points
edited the question 2024-10-03T21:11:13.47+00:00
Akshay kumar Mandha 390 Reputation points Microsoft Vendor
1 answer

Pivot query result (column name will change)

Hi there, Have been working on a huge database task and one part of it is the below. How do i pivot this 1 row with dynamic columns (column names will change) Query: select top 1 * from INFORMATION_SCHEMA.columns Output should be ColumnName |…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 questions
asked 2024-10-02T23:08:15.1166667+00:00
RJ 166 Reputation points
answered 2024-10-03T20:38:33.17+00:00
Amira Bedhiafi 24,451 Reputation points
1 answer

SQLServerException: An item with the same key has already been added.

Running the query: SELECT name FROM [" + catalog + "].sys.schemas ORDER BY name I got exception: 10:05:26 [com.microsoft].sqlserver.jdbc.SQLServerException: An item with the same key has already been added. RequestId:…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-10-03T17:18:28.88+00:00
dprutean 0 Reputation points
answered 2024-10-03T20:35:20.94+00:00
Amira Bedhiafi 24,451 Reputation points
2 answers

What is the limit on the number of logical servers (SQL) per subscription?

I have found conflicting information: From https://learn.microsoft.com/en-us/azure/azure-sql/database/logical-servers?view=azuresql&tabs=portal#overview I see 6 Is restricted by a quota within the parent subscription (six servers per subscription by…

Azure SQL Database
asked 2024-10-03T15:28:57.2133333+00:00
Carl Létourneau 0 Reputation points
commented 2024-10-03T20:23:24.9033333+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
0 answers

Azure SQL MI degraded performance compared to On Prem

Hi We recently migrated our On Prem SQL Server databases to Azure SQL MI using azure data migration service in Azure Data Studio We see a degradation in performance. Queries are taking way more time SQL On prem - 3s - SSMS/ADS SQL Mi - 1m 22s -…

Azure SQL Database
asked 2024-10-03T10:02:36.5033333+00:00
Nitya V 45 Reputation points
commented 2024-10-03T19:09:16.9533333+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
1 answer

Azure SQL DBCC ShrinkDatabase takes too long

Hi there, I ran DBCC shrinkdatabase in Azure sql provisioned with 10 vcores. The one DB size is 500GB and other is 800GB. Both ran for 12 hrs and progress was only 30 percent. Sometimes it gets killed since ETL jobs start to run every 12 hrs. Anything im…

Azure SQL Database
asked 2024-10-01T14:53:18.8733333+00:00
RJ 166 Reputation points
commented 2024-10-03T18:33:04.54+00:00
NIKHILA NETHIKUNTA 2,395 Reputation points Microsoft Vendor
0 answers

Cannot connect to SQL Database. Please contact SQL server team for further support.

Hello support from time to time i get an error that username/password is invalid for database. However database is up and running and in use. below are the infromation activityid 701ef079-7056-4d6b-b941-c2e2f011e57a

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,665 questions
asked 2024-10-01T08:13:02.49+00:00
Ninoslav Zekic 10 Reputation points
commented 2024-10-03T18:28:19.2933333+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
2 answers

clients are unable to receive any data, resulting in HTTP 5XX errors. Below are the details of the problem and the steps I have taken to resolve it.

I am encountering issues deploying my Node.js application to Azure App Service. While the server starts successfully and connects to the database, clients are unable to receive any data, resulting in HTTP 5XX errors. Below are the details of the problem…

Azure SQL Database
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
982 questions
asked 2024-09-30T10:19:54.6833333+00:00
בנימין זיידנר 20 Reputation points
commented 2024-10-03T18:25:23.1566667+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
1 answer

MSSQL - Error Creating Managed Instance - Polling Failed

Trying to deploy a MSSQL Managed Instance via terraform. We have checked our parameters and configurations. We have reached out to our app support team and continue to fail to deploy. We are getting the following error message: --Please note I have…

Azure SQL Database
asked 2024-09-27T21:12:52.9666667+00:00
Gunnar Smith 0 Reputation points
commented 2024-10-03T18:22:36.0933333+00:00
Mahesh Kurva 240 Reputation points Microsoft Vendor
2 answers

Unable to unit test AzureResourceManager.java operations

I have this method in my java code and I am trying to unit test this AzureResourceManager azure = // assume that this is getting initialised properly return azure.sqlServers() .manager() .serviceClient() .getJobAgents(); I am not…

Azure SQL Database
asked 2024-09-29T08:28:31.7066667+00:00
Ayush Shrivastava 100 Reputation points
commented 2024-10-03T18:13:46.3266667+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
0 answers

Vulnerability Assessment is enabled on this server or one of its underlying databases with an incompatible version.

despite continuing to use the classic configuration, we are repeatedly encountering the same error. It seems that this issue persists even though we have not actually transitioned to the express configuration. Im trying to deploy using ARM template

Azure SQL Database
Microsoft Defender for Cloud Apps
Microsoft Defender for Cloud Apps
A Microsoft cloud access security broker that enables customers to control the access and use of software as a service apps in their organization.
143 questions
asked 2024-10-03T18:10:35.47+00:00
Poovarasan Annadurai 20 Reputation points
1 answer

Azure SQL database restore to Synapse

we need to do restore sql server database from restore point to dedicated sql pool on synapse on same resource group we are trying to do restore azure sql server db on same restore group where we have synapse but it ends up with error ERROR1.JPG Command…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,914 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-09-11T14:01:57.8966667+00:00
Andrea Galardi 0 Reputation points
commented 2024-10-03T16:18:03.0366667+00:00
Molly VanderVelde 51 Reputation points
1 answer

enable auditing on sql managed instance

Hi Everyone, How can we enable db auditing on SQL Managed instance

Azure SQL Database
asked 2024-10-03T14:31:48.9466667+00:00
Kaustubh Tawde 0 Reputation points
commented 2024-10-03T16:14:21.7766667+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Service account to connect power BI to SQL database Entre ID credential or service principal

I have got an Azure SQL database setup, Power BI requires access to this database. However there is an existing account for this purpose, the problem we are having is that the password often expires. Is there a way to get around this problem or should we…

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,668 questions
asked 2024-09-23T20:16:15.1233333+00:00
MrFlinstone 541 Reputation points
accepted 2024-10-03T14:41:32.95+00:00
MrFlinstone 541 Reputation points
0 answers

Azure Data Application

Hello all, I am a teacher with student who is trying to develop and application for a company for a senior project using azure. The requirements are to get data from a database within azure and display metrics to be used by the company. We don't know…

Azure SQL Database
asked 2024-10-02T17:28:06.0766667+00:00
Dan Ballard 0 Reputation points
edited a comment 2024-10-03T10:51:58.34+00:00
Mahesh Kurva 240 Reputation points Microsoft Vendor
2 answers

Intermittent Error 500 on First Access – Works After Multiple Refreshes

I’m encountering a recurring 500 Internal Server Error when trying to access my web application for the first time after a period of inactivity. The issue consistently occurs on the initial access or after some idle time, but after 2-3 refreshes, the…

Azure SQL Database
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
925 questions
asked 2024-09-20T10:44:55.1966667+00:00
André Costa 0 Reputation points
edited the question 2024-10-03T08:27:29.0933333+00:00
KapilAnanth-MSFT 44,936 Reputation points Microsoft Employee
2 answers

Microsoft SQL Server, Error: 10054

I have a problem with Microsoft SQL Server Management Studio when I'm at home with a internet that does not have IP address as usually when I'm not in my condo unit and almost sometimes impossible to connect or even list the tables.. but if i use SQL…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-10-02T15:38:06.3566667+00:00
LA METISSE 0 Reputation points
answered 2024-10-03T03:41:20.8333333+00:00
Alberto Morillo 33,861 Reputation points MVP
2 answers

how to give entra Id access to azure sql database

give Entra Id access to azure sql database to another user

Azure SQL Database
asked 2024-02-07T20:59:57.32+00:00
Ray, David 0 Reputation points
commented 2024-10-02T22:40:15.3066667+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
3 answers

What is the best choice for this scenario - CTE or View

Hello Team, I have a scenario where in the source data is in an Azure SQL DB. The data in the source is stored in the form of snapshots. For Ex:- Day1 - 500K Records, Day2 - 510K Records - Day3 - 520K Records (Total - 1.53M records). All the tables the…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 questions
asked 2024-02-07T11:11:16.49+00:00
Nagesh CL 646 Reputation points
edited an answer 2024-10-02T22:22:32.6966667+00:00
Raja S 0 Reputation points