5,400 questions with Azure SQL Database tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

Unable to create ADF Linked Service to Azure SQL database using Self-Hosted Integrated Runtime

Hi all, I am having trouble creating a Linked Service that connects to one of our Azure SQL databases. After entering all required Linked Service fields and testing the connection using our self-hosted integration runtime, I received the following error…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
asked 2024-06-07T21:59:28.4466667+00:00
Ricardo-2519 20 Reputation points
accepted 2024-07-11T20:51:28.44+00:00
Ricardo-2519 20 Reputation points
2 answers

Azure SQL Database not supporting DBCC SHRINKFILE

Hey guys, I have recently tried to shrink a database file in Azure SQL Database, but am getting a message saying this function is not supported in this version of SQL Server. Anybody know when this support was removed? What is the replacement in Azure…

Azure SQL Database
asked 2021-03-10T04:57:13.093+00:00
Stephen Planck 21 Reputation points
answered 2024-07-11T19:41:19.72+00:00
Balmukund 81 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How do I access my Azure SQL Database using my managed identity?

Hi all; I have a managed identity created. How do I (step by step please as I remember this as being complicated): Set the database to allow access via managed identity? What is the connection string I then provide to the production server? How do I…

Azure SQL Database
asked 2024-07-08T18:09:17.6133333+00:00
David Thielen 2,776 Reputation points
accepted 2024-07-11T16:37:53.4133333+00:00
David Thielen 2,776 Reputation points
1 answer

How to identify it is one update operation for table which has enable cdc

We know that we can use change data capture to monitor the data change on sql database table. I tried to run UPDATE TABLENAME SET PKColumn=NewValue where PKColumn=OldValue We can see that there will be one row marking the delete operation and one row…

Azure SQL Database
asked 2024-07-11T08:51:41.18+00:00
WisonHii 81 Reputation points
answered 2024-07-11T13:25:20.5+00:00
Amira Bedhiafi 19,616 Reputation points
1 answer One of the answers was accepted by the question author.

price in restore DB + where the restore happened

Hi, I have two questions regarding the backup of the DB: regarding the price written estimated cost per month, does it mean that one restore will cost me this price per month? Regarding the second question, where did the restore go ? Does it…

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,186 questions
Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,329 questions
asked 2024-07-08T16:10:10.1133333+00:00
Lior Tomer 25 Reputation points
accepted 2024-07-11T08:30:41.2966667+00:00
Lior Tomer 25 Reputation points
0 answers

Unable to send message from Azure SQL to Service Bus

The goal is to send messages to Service Bus from Azure SQL Server. I have added the Managed Identity to the queue with the Azure Service Bus Data Owner permission. When I run the code to set up the credential, there is no error. OPEN MASTER KEY…

Azure SQL Database
Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
587 questions
asked 2024-07-03T18:31:40.7866667+00:00
Spencer Thompson (Network) 0 Reputation points
edited a comment 2024-07-10T22:54:02.5766667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
0 answers

Azure Entra ID Authentication fails on Azure APP Services

On Local applicaitons we are able to validate connection Server=tcp:XXXXX.database.windows.net,1433;Initial Catalog=demo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default; Once deployed in azure same…

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,307 questions
asked 2024-07-10T18:52:40.6633333+00:00
21887231 0 Reputation points Microsoft Vendor
commented 2024-07-10T21:05:01.0866667+00:00
Erland Sommarskog 106.3K Reputation points
2 answers

How to solve problem Microsoft ODBC Driver 17 for SQL Server cannot be found

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052310 Start time: 2021-05-06 08:17:41 End time: 2021-05-06 08:22:57 Requested…

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,307 questions
Windows 10 Setup
Windows 10 Setup
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,919 questions
asked 2021-05-06T04:21:37.64+00:00
nabiella 1 Reputation point
commented 2024-07-10T20:39:30.8966667+00:00
Falade, Michael (LRC) 20 Reputation points
1 answer

Invalid value specified for connection string attribute 'Authentication' (0) (SQLDriverConnect)

I am trying to connect to Azure SQL Database using user assigned managed identity. While configuring the Azure functions I have added the db_reader permission to it. But when I am connecting to the database using the pyodbc driver I am getting…

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,632 questions
asked 2024-07-09T13:02:36.6466667+00:00
Shashi Kumar Soni 1 Reputation point
commented 2024-07-10T18:52:30.4866667+00:00
Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
1 answer

Azure SQL database S4 pricing tier, what storage type using (HDD or SSD)

Azure SQL database S4 pricing tier, what storage type using (HDD or SSD)

Azure SQL Database
asked 2024-07-10T05:56:41.8166667+00:00
Akash Kumar Mandal 0 Reputation points
edited an answer 2024-07-10T13:41:57.4833333+00:00
Alberto Morillo 33,421 Reputation points MVP
6 answers

CosmosDB Analytical store delete changes in sql sink

Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…

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,667 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,533 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
asked 2024-04-30T13:52:46.2133333+00:00
Kuldeep Bhati 0 Reputation points
answered 2024-07-10T12:16:09.6333333+00:00
Kuldeep Bhati 0 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Data Factory Copy Geometry data from Azure SQL to Azure Cosmos DB

Hi Team, I am trying to copy over data from a table in Azure SQL database containing geometry type columns. When i created a linked service and preview data get the error message 'Type=Newtonsoft.Json.JsonSerializationException,Message=Error getting…

Azure SQL Database
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,533 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,120 questions
asked 2024-07-10T05:11:28.7133333+00:00
Vijay Rudrasamudram 40 Reputation points
commented 2024-07-10T11:03:04.6+00:00
Vijay Rudrasamudram 40 Reputation points
2 answers

Why is the data IO percentage for my elastic pool around 50% while a database in the pool is hitting the 100%?

I switched from dtu pricing model to the vCore model (seems to have higher IOPS limit). But it looks like every DB in the pool can only use part of this IO operations limit? Here there are 2 dbs in the pool and only the one shown has any usage. The per…

Azure SQL Database
asked 2023-04-20T13:44:40.8866667+00:00
Roel Horeman 5 Reputation points
answered 2024-07-10T10:52:32.5966667+00:00
Vítor Pombeiro 0 Reputation points
2 answers

Azure wont let me crate free data base offer

I'm unable to redeem the free data base offer, I get the follwing error "status": "Failed", "error": { "code": "ProvisioningDisabled", "message": "Provisioning of…

Azure SQL Database
asked 2024-07-06T21:15:55.5+00:00
misael gonzalez soria 0 Reputation points
answered 2024-07-10T05:51:31.74+00:00
ShaktiSingh-MSFT 14,376 Reputation points Microsoft Employee
2 answers

Upload and restore .bak file to Azure SQL Database from Local Machine

I have a .bak file on my machine I am trying to restore into an azure database. I then created an Azure storage/blob account to hold this file, to restore via ssms but unfortunately, the file is large (about 35GB) and crashes my machine multiple times.…

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,307 questions
asked 2024-07-09T09:06:52.5033333+00:00
Babawale Dawodu 90 Reputation points
commented 2024-07-09T21:50:27.26+00:00
Babawale Dawodu 90 Reputation points
1 answer

ACI needs MS SQL access which is on an azure VM, how do I achieve this?

Hi, I have deployed a container instance which has a connection string which points to a SQL database which is hosted on an azure virtual machine. The virtual machine has its own public IP address. However, the container instance cannot "see"…

Azure SQL Database
asked 2024-07-03T11:19:30.1433333+00:00
Sean Kelly 0 Reputation points
edited the question 2024-07-09T13:20:48.7266667+00:00
KapilAnanth-MSFT 40,911 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure SQL End of Life Notification

I received a notification from my cloud team that mentions Azure DB for MySQL Single Server, PostgreSQL Single Server, and Maria DB are being retired. I am new to Azure and would like to know if Azure SQL DB and server will be retired as well, so i can…

Azure SQL Database
asked 2024-07-08T13:10:54.5266667+00:00
Mikhael Andy 20 Reputation points
edited the question 2024-07-08T16:15:58.2233333+00:00
VarunTha 5,740 Reputation points Microsoft Vendor
3 answers

Server Password change on Mac

Does anyone know how to change password inside azure data studio on a MacBook m1?

Azure SQL Database
asked 2024-02-27T09:28:21.61+00:00
commented 2024-07-08T10:04:51.88+00:00
BALLA NAGA SAI 0 Reputation points
4 answers

DataSource.Error: Microsoft SQL - Power BI

Good day, I have a problem with Power BI, when I try to import a database it generates the following error: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process.…

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,307 questions
asked 2024-07-04T14:38:30.8166667+00:00
Gaston N Escobar 0 Reputation points
commented 2024-07-08T04:16:02.92+00:00
ShaktiSingh-MSFT 14,376 Reputation points Microsoft Employee
2 answers

SQL Server deployment DEV to UAT to Prod

Hi, I would like to know about different deployment options for azure SQL server from dev to higher environments. We are doing ETL in ADF and loading data into Azure SQL server. How do we move the tables/views/sps etc to other environments? Is there an…

Azure SQL Database
asked 2024-07-04T12:42:05.57+00:00
Santhi Dhanuskodi 205 Reputation points
commented 2024-07-08T04:05:25.05+00:00
ShaktiSingh-MSFT 14,376 Reputation points Microsoft Employee