5,224 questions with Azure SQL Database tags

Sort by: Updated
Updated Created Answers
1 answer

Azure Data Studio - Data Migration Extension

Hi We used the data migration extension in Azure data studio to migrate sql server db to SQL MI We stored all the backups to hte azure blob container We started the migration Once all the backups showed restored. We marked the db as read only. We…

Azure SQL Database
asked 2024-05-24T18:21:32.1466667+00:00
Nitya V 40 Reputation points
answered 2024-05-24T18:49:45.2066667+00:00
Gowtham CP 1,255 Reputation points
2 answers

How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)

How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…

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.
12,894 questions
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V 40 Reputation points
commented 2024-05-24T18:31:16.7933333+00:00
Nitya V 40 Reputation points
4 answers

Transactional Replication on a SQL Managed instance as a subscriber with pull subscription

We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this

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.
12,894 questions
asked 2024-05-16T12:03:46.98+00:00
Nitya V 40 Reputation points
commented 2024-05-24T18:30:23.2033333+00:00
Nitya V 40 Reputation points
3 answers

ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables

I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…

Azure SQL Database
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
314 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
833 questions
asked 2024-04-23T20:44:30.33+00:00
EFS 0 Reputation points
answered 2024-05-24T16:30:56.28+00:00
EFS 0 Reputation points
3 answers

Date column in sink table is getting NULL values

Hi, I have two fields in my source .csv file which is Date1(format- YYYYMMDD) and Date2(format- YYYYMMDD), I have corresponding table in my SQL database with the same fields with data type as datetime2. Now I am trying to load the data from my source…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,750 questions
asked 2024-04-04T13:50:00.5366667+00:00
Harshita Vishwakarma 45 Reputation points
answered 2024-05-24T14:39:32.4666667+00:00
Pinaki Ghatak 2,400 Reputation points Microsoft Employee
1 answer

Azure Data Studio - Can we do online migratation of same db on prem sql to two different target(sql manged insance)

Hi Azure Data Studio - Can we do online migratation same db (on prem sql) to two different target(sql manged instance) wiht azure migration extension in azure data studio I am wondering what does the tool do as part of cutover.What activities are done…

Azure SQL Database
asked 2024-05-22T08:02:52.0966667+00:00
Nitya V 40 Reputation points
edited a comment 2024-05-24T12:57:42.7233333+00:00
Nitya V 40 Reputation points
0 answers

Using Entra ID Auth Only in ADF + Azure SSIS IR solution

Hi, We're currently working on complying with Microsoft cloud security benchmark in our tenant and ran into an issue with our Azure Data Factory service. To comply, we need to have only Entra ID Auth on our Azure SQL DBs. We're using Azure Data Factory…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,750 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,844 questions
asked 2024-05-24T09:37:29.6033333+00:00
Johan Lindholm 0 Reputation points
0 answers

Azure Elastic Job execution failing

I have created an Azure Elastic Job following the example here: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql However, the job execution if failing with the following: Failed to determine members…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,005 questions
asked 2024-05-23T21:41:42.6033333+00:00
Scott Klein 161 Reputation points
commented 2024-05-24T05:39:47.08+00:00
ShaktiSingh-MSFT 13,991 Reputation points Microsoft Employee
1 answer

Azure SQL Database Varbinary data type

I am facing issues while retrieving varbinary data from sql server tables ,Performance is taking a toll , 4 lakh records are taking around 20 hrs to read and write into target db tables

Azure SQL Database
asked 2024-05-23T16:18:17.9133333+00:00
Sujan Athelli 0 Reputation points
answered 2024-05-24T05:30:02.82+00:00
Olaf Helper 41,411 Reputation points
1 answer

SQL Access Strategy

I would like a strategy for the use of Azure SQL with our cloud environment. The DB is in azure SQL. I would like to come up with a solution for giving access to developers and extended/other teams for dev/support needs. WE have to add users and give…

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,471 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.
12,894 questions
asked 2024-05-23T06:06:17.2233333+00:00
Santhi Dhanuskodi 145 Reputation points
commented 2024-05-24T05:19:17.94+00:00
ShaktiSingh-MSFT 13,991 Reputation points Microsoft Employee
1 answer

During database migration in online mode using Azure data studio status is restoring only on sqlmi.

During database migration in online mode using Azure data studio status is restoring only on sqlmi. it's not changing since long time. Though Azure data studio shows restored and Data migration service shows ready for cutover. Data is around 24 GB only.

Azure Database Migration service
Azure SQL Database
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
100 questions
asked 2023-10-11T09:35:48.61+00:00
Pratibha Agrawal 0 Reputation points
commented 2024-05-24T03:48:03.2033333+00:00
ShaktiSingh-MSFT 13,991 Reputation points Microsoft Employee
4 answers One of the answers was accepted by the question author.

syncdata db has this error "Database re-provisioning failed with the exception "

I have an Azure sql db that I have a data sync with an on prem db. The sync was working and all was good. 1/31 we added a column to a table in the on prem db. I added the same column to my Azure sql db and refreshed the schema for the data sync. The new…

Azure SQL Database
asked 2024-02-02T14:12:42.7766667+00:00
Janet Putnam 45 Reputation points
edited a comment 2024-05-23T20:34:35.8633333+00:00
Oury Ba-MSFT 16,886 Reputation points Microsoft Employee
1 answer

what is best practice using Azure SQL Database ?

hi? My customer decided to use Azure SQL Database. In Azure, you can create and use multiple databases in one Azure SQL Database Server. Is there any problem if I use it like this? Or do I need to create a SQL Server for each database? The people who…

Azure SQL Database
asked 2024-05-23T00:41:17.4966667+00:00
KIM 0 Reputation points
commented 2024-05-23T20:30:47.2533333+00:00
Nikhil Mandaara 41 Reputation points
7 answers One of the answers was accepted by the question author.

Microsoft SQL Server Studio - Dark Mode

Is there any official method to use Microsoft SQL Server Management Studio Studio with Dark Mode?

Azure SQL Database
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,696 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.
12,894 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
asked 2023-12-19T13:11:52.4966667+00:00
Kıvanç ÖZDEMİR 125 Reputation points
commented 2024-05-23T19:53:28.53+00:00
Yitzhak Khabinsky 25,201 Reputation points
0 answers

How can I get more details on the costs of a database usage on azure?

I have an SQL database that seems rather costly for the usage that I make of it (1000$/mo for ~$4Gb storage + less than 30 of compute per day) but i can't figure out why exactly from the cost management interface. Is it possible to see a break down of…

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,130 questions
asked 2024-05-23T17:29:41.2566667+00:00
Antoine M 0 Reputation points
commented 2024-05-23T18:04:08.2633333+00:00
Vahid Ghafarpour 19,125 Reputation points
1 answer One of the answers was accepted by the question author.

How can I use Microsoft Entra-only authentication for my nextjs application using mssql and Azure SQL Database

I'm building a fullstack application using NextJs and Azure SQL database. The database is Microsoft Entra-only authentication. I'm using NPM packages mssql for querying the database and @azure/msal-browser and @azure/msal-react for single sign on. The…

Azure SQL Database
Microsoft Entra
asked 2024-05-17T20:58:27.2466667+00:00
Kofi Adutwum 20 Reputation points
commented 2024-05-23T17:38:32.9066667+00:00
Oury Ba-MSFT 16,886 Reputation points Microsoft Employee
0 answers

Issue Connecting With An Azure SQL Database from .NET WinForms Application

I'm having an issue connecting to an Azure SQL database from a WinForms application after it has been packaged using InstallShield. The database exists on a virtual network and I'm using a virtual network gateway point-to-site connection. The database is…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,857 questions
Azure SQL Database
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,202 questions
asked 2024-05-22T16:37:29.1633333+00:00
Tom 1 Reputation point
commented 2024-05-23T17:32:23.2866667+00:00
Tom 1 Reputation point
2 answers

Can't able to connect the VM installed postgresql from ADF

Hi Team, We are unable to access the PostgreSQL from the ADF linked server. it's a azure PostgreSQL flexible server, and we have enabled the "Allow public services" setting within Azure for this server. However, we are still unable to create a…

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,382 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,281 questions
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,471 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,750 questions
asked 2024-05-14T06:10:02.6633333+00:00
Aravind 20 Reputation points
commented 2024-05-23T16:51:12.9166667+00:00
ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
1 answer

Could not open a connection to SQL Server After publishing an ASP.NET Web project to azure using VS2022

There is a bug in the publishing code because I used the UI to publish my on premise app from visual studio 2022 and it didn't set the App service or the Sql Server correctly because The app service can't access the database and I get the follwing…

Azure SQL Database
asked 2024-05-22T18:26:27.44+00:00
Ronen 0 Reputation points
edited a comment 2024-05-23T13:36:52.2366667+00:00
Ronen 0 Reputation points
0 answers

Connection failed

Spark job failed: { "text/plain":…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,005 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.
12,894 questions
asked 2024-05-23T06:30:07.4366667+00:00
Rohith Vinnakota (Quadrant Technologies) 0 Reputation points
commented 2024-05-23T08:30:36.7766667+00:00
ShaktiSingh-MSFT 13,991 Reputation points Microsoft Employee