6,464 questions with Azure SQL Database tags

Sort by: Updated
0 answers

I need to speak with a live person regarding Upgrade to TLS 1.2 for Azure SQL Database by 31 August 2025

I am not sure I did the upgrade correctly and need confirmation vbefore deadline.

Azure SQL Database
asked 2025-08-29T18:15:35.6733333+00:00
McCaleb at Revenue Simplified 0 Reputation points
commented 2025-08-29T19:29:13.8433333+00:00
Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator
0 answers

Create index on hyperscale SQL database inexplicably stops on large table (using WITH... ONLINE and RESUMABLE))

We're trying to create an index on a very large table in our PollenSenseLive db. The first time we tried, it failed after a few days, and we deduced from the start time that the server had rebooted. Unfortunately, we were outside of the short time to…

Azure SQL Database
asked 2025-08-27T20:12:49.12+00:00
Nathan Allan 0 Reputation points
commented 2025-08-29T19:20:30.68+00:00
Oury Ba-MSFT 21,111 Reputation points Microsoft Employee Moderator
1 answer

Can't create a database in Azure

The Azure portal accepts my login but when I try to create a database it indicates a problem arose when "attempting to retrieve access tokens". Trying to sign in again yields the same error. What can I do to resolve this problem?

Azure SQL Database
asked 2025-08-25T07:00:28.3766667+00:00
RogerSchlueter-7899 1,486 Reputation points
edited a comment 2025-08-29T15:47:14.3566667+00:00
Swapnesh Panchal 5 Reputation points Microsoft External Staff Moderator
1 answer

Windows Authentication for Entra ID for Azure SQL MI

Hi Team, I recently come across a use case where we have to use Windows Authentication for Entra ID for SQL MI. My question is based on Microsoft documentation…

Azure SQL Database
asked 2025-08-27T01:20:15.4066667+00:00
Zahid Yaqub 0 Reputation points
commented 2025-08-29T11:55:13.0033333+00:00
Abhisek Mishra 85 Reputation points Microsoft External Staff Moderator
0 answers

DATA/SCHEMA REPLICATION IN HYPERSCALE

We have an existing schema in our Azure SQL Database that contains several hundred tables. Some tables contain data while others are empty. Our requirement is to create a new schema in the same database that replicates the full structure of the…

Azure SQL Database
asked 2025-08-29T08:49:34.93+00:00
Janice Chi 620 Reputation points
edited a comment 2025-08-29T09:46:36.5333333+00:00
Saraswathi Devadula 12,675 Reputation points Microsoft External Staff Moderator
1 answer

SQLException error: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

Here is the error from application server: Source is Azure SQL Database Exception during aggregation. Reason: java.lang.RuntimeException: sailpoint.connector.ConnectorException: The application script threw an exception: java.sql.SQLException:…

Azure SQL Database
asked 2025-08-19T23:43:58.83+00:00
Vijay Kumar 2,061 Reputation points
commented 2025-08-29T09:36:38.0166667+00:00
Kalyani Kondavaradala 1,015 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

I need to create a SQL MI in UK West but don't have the quota

I need to increase my quota to allow to deploy a SQL MI in UK West. 4 cores is fine.

Azure SQL Database
asked 2025-08-28T13:26:00.1933333+00:00
Christian Bolton 0 Reputation points
accepted 2025-08-29T09:13:57.0966667+00:00
Christian Bolton 0 Reputation points
1 answer

Why can't I get a Connection from SqlConnect() on my PC to Azure SQL Database?

I am new to Azure. I have created an Azure SQL Database. I can access the database with SMSS and look through the database using MicrosoftEntraPassword or MicrosoftEntraIntegrated. When I use my application running on same host as SMSS it fails. var…

Azure SQL Database
asked 2025-08-28T17:10:04.33+00:00
Mark Siminski 0 Reputation points
commented 2025-08-29T08:22:35.23+00:00
Swapnesh Panchal 5 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to retrieve data from an SQL database using Python's Pyodbc with tokens?(Oauth)

conn_str = f'DRIVER={{ODBC Driver 18 for SQL Server}};SERVER={server},1433;DATABASE={database};Encrypt=yes;TrustServerCertificate=yes;' token_bytes = access_token.encode('utf-8') token_struct = struct.pack('<I', len(token_bytes)) +…

Azure SQL Database
asked 2025-08-28T10:28:22.64+00:00
Shinichiro Takabe 0 Reputation points
edited a comment 2025-08-29T00:38:40.7+00:00
Shinichiro Takabe 0 Reputation points
0 answers

Optimizing Bulk Merge into Azure SQL Hyperscale Without Staging Tables

JDBC Bulk Update Support Can the Microsoft JDBC driver handle true bulk updates (not just inserts), or is the recommendation always to use a staging table and in-database MERGE? Are there driver settings (e.g., `sendStringParametersAsUnicode`,…

Azure SQL Database
asked 2025-08-25T15:51:48.54+00:00
Janice Chi 620 Reputation points
commented 2025-08-28T18:25:57.73+00:00
Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator
1 answer

merge into Azure SQL Hyperscale main tables

Context of our project Source: IBM DB2 iSeries CDC into Kafka Phases: one-time historical, catch-up (bounded CDC), and near-real-time streaming Target: Azure SQL Database Hyperscale Constraints: Healthcare data; correctness and replay are top priority;…

Azure SQL Database
asked 2025-08-27T15:14:51.32+00:00
Janice Chi 620 Reputation points
commented 2025-08-28T16:50:31.6933333+00:00
Smaran Thoomu 29,500 Reputation points Microsoft External Staff Moderator
1 answer

unable to get free credit or pay as go

unable to get free credit or pay as go, tried multiple times on different days , sometimes microsoft site issue, sometimes bank is not able to recognise the payment method

Azure SQL Database
asked 2025-08-28T13:22:06.63+00:00
Kiran Dhamale 0 Reputation points
edited an answer 2025-08-28T16:14:02.3733333+00:00
Alberto Morillo 34,926 Reputation points MVP Volunteer Moderator
1 answer

Azure SQL managed instance Dev test version stops everything without instructing it to stop

Without reason my Azure SQL managed instance developer/test edition stops. I want to convince the board the go from MySQL to Azure SQL Managed Instance. For that I need to build parts of our solution to show prototypes with real data for a period of…

Azure SQL Database
asked 2025-08-27T05:28:14.3433333+00:00
Cees Bolijn - Sflex Sign Software 0 Reputation points
commented 2025-08-28T04:43:22.7066667+00:00
Cees Bolijn - Sflex Sign Software 0 Reputation points
2 answers

Disaster Recovery for Azure DB

Hi Everyone,   I would like to get some clarifications regarding Disaster Recovery (DR) and operational failure scenarios for our Hyperscale database.   Database details: Size: ~110 GB vCore: 4 Compute tier: Provisioned Hardware type: Gen-5 Region:…

Azure SQL Database
asked 2025-08-25T09:43:04.3566667+00:00
Vignesh RS 0 Reputation points
commented 2025-08-27T11:51:44.8033333+00:00
VRISHABHANATH PATIL 85 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

My Azure SQL dbs are down and I need Azure Suppport

Hello My sites are down and I cant place a ticket to get ahold of Azure Support I have two SQL databases down in the East Region without any notice of maintainace

Azure SQL Database
asked 2025-08-14T03:55:37.4333333+00:00
Cameron O'Rourke 45 Reputation points
edited a comment 2025-08-26T19:52:27.7433333+00:00
Steven Tyler 0 Reputation points
1 answer

Azure SQL Hyperscale – Best approach to merge large main table with extension tables

We are working with Azure SQL Hyperscale. The environment has one large table of around 19 TB, along with two smaller extension tables of around 1.5 TB each. These extension tables (_EXT) share the same primary keys as the main table but contain…

Azure SQL Database
asked 2025-08-19T17:02:13.39+00:00
Janice Chi 620 Reputation points
commented 2025-08-25T17:26:56.1933333+00:00
Oury Ba-MSFT 21,111 Reputation points Microsoft Employee Moderator
2 answers One of the answers was accepted by the question author.

Azure SQL zone redundancy pricing with DTU purchase model

On the Azure SQL Database pricing page I can see there is a price difference between locally redundant and zone redundant database with the vCore purchase model. However, I cannot identify the difference with DTU-based model. My question is:…

Azure SQL Database
asked 2022-09-14T14:37:15.903+00:00
metalheart 411 Reputation points
commented 2025-08-25T07:42:43.88+00:00
Janne Kujanpää 261 Reputation points
1 answer One of the answers was accepted by the question author.

How can my client connect Power BI to Azure SQL Database?

Hi all, I have an Azure SQL Database and my client (located in Brazil) wants to connect to it using Power BI Desktop. They are also using a VPN on their side. Right now, they are unable to connect. I’m not sure what needs to be done on the Azure SQL…

Azure SQL Database
asked 2025-08-25T03:01:06.9133333+00:00
YERNAIDU SIRAPARAPU 105 Reputation points
accepted 2025-08-25T06:48:31.9166667+00:00
YERNAIDU SIRAPARAPU 105 Reputation points
1 answer

String Conversion: Preserving Leading Zero for Hashing

We build an MD5 hash by concatenating multiple column values across systems (DB2 for iSeries and Azure SQL). Some source columns are DECIMAL/NUMERIC. When converting decimals to string in DB2 using CHAR/VARCHAR, values like 0.0123 sometimes become .0123…

Azure SQL Database
asked 2025-08-21T10:36:09.06+00:00
Janice Chi 620 Reputation points
answered 2025-08-22T22:30:36.34+00:00
Oury Ba-MSFT 21,111 Reputation points Microsoft Employee Moderator
1 answer

SQL Managed Instance resolving to Virtual Cluster IP instead of Private Endpoint IP from on-prem DNS

We have a SQL Managed Instance (MI) deployed with a Private Endpoint. The private DNS zone (privatelink.d<guid>.database.windows.net) is correctly configured and linked to the MI's virtual network. We are using an on-prem Windows Server DNS to…

Azure SQL Database
asked 2025-08-20T23:11:09.7366667+00:00
Naveen Vasanthakumar 20 Reputation points
commented 2025-08-22T16:37:28.0566667+00:00
Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator