Azure SQL Database
An Azure relational database service.
5,249 questions
2 answers
Should I update statistics immediately after migrating to Azure SQL Server Managed Instance
I am migrating my 4TB database of Microsoft SQL Server 2016 2 node AG cluster from on-premises to Azure SQL Managed Instance. I am using Azure Data Studio to migrate through full backup and continuously applying log backup. This backup will be ongoing…
asked 2024-05-27T11:15:24.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Aakash CK(P)
0
Reputation points
answered 2024-05-27T21:41:18.89+00:00
Erland Sommarskog
102.6K
Reputation points
3 answers
One of the answers was accepted by the question author.
im trying to reset password for my SQL in azure
Hi everyone, i think i hve forgot my password to my sql account. i im trying ways to reset it, by nithing helps, any idea on this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 61%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
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…
asked 2024-05-23T17:29:41.2566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Antoine M
0
Reputation points
commented 2024-05-27T19:39:48.65+00:00
SadiqhAhmed-MSFT
39,326
Reputation points Microsoft Employee
3 answers
How to read excel document from sharepoint directly dump it in Azure SQL using Azure data factory ?
I want to access excel document from SharePoint and without downloading that to data lake or blob storage, use data factory to read the content of it and directly dump it in Azure SQL.
asked 2024-04-15T07:24:19.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
heta desai
247
Reputation points
answered 2024-05-27T10:18:57.5066667+00:00
Pinaki Ghatak
2,405
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…
asked 2024-05-22T08:02:52.0966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
40
Reputation points
commented 2024-05-27T08:31:04.7133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
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…
asked 2024-04-04T13:50:00.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Harshita Vishwakarma
45
Reputation points
commented 2024-05-27T08:03:39.5066667+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
2 answers
I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues.
I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues.…
asked 2024-05-21T02:20:06.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 82%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
ram boyapati
15
Reputation points
commented 2024-05-25T08:47:22.4533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 13%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Shaukat
0
Reputation points
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
asked 2024-05-23T16:18:17.9133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sujan Athelli
0
Reputation points
commented 2024-05-25T07:02:05.0233333+00:00
Sujan Athelli
0
Reputation points
1 answer
Azure upgrade email broken link. How to upgrade?
Hi Everyone, I received an email from azure-noreply@microsoft.com stating, "Upgrade by June 23, 2024 to save your data and keep building in Azure". The email has an "Upgrade now >" link which goes…
asked 2024-05-24T21:57:49.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 30%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Scholasticus, Tom
0
Reputation points
answered 2024-05-24T22:34:47.6533333+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 50%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
1 answer
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 SQL Database
An Azure relational database service.
5,249 questions
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,020 questions
asked 2024-05-23T21:41:42.6033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 66%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
161
Reputation points
answered 2024-05-24T05:39:47.08+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
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…
asked 2024-05-23T06:06:17.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
165
Reputation points
commented 2024-05-24T05:19:17.94+00:00
ShaktiSingh-MSFT
14,081
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.
asked 2023-10-11T09:35:48.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pratibha Agrawal
0
Reputation points
commented 2024-05-24T03:48:03.2033333+00:00
ShaktiSingh-MSFT
14,081
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…
asked 2024-02-02T14:12:42.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 7.000000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Janet Putnam
45
Reputation points
edited a comment 2024-05-23T20:34:35.8633333+00:00
Oury Ba-MSFT
16,901
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…
asked 2024-05-23T00:41:17.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
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
Azure SQL Database
An Azure relational database service.
5,249 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,725 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,950 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,211
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…
asked 2024-05-17T20:58:27.2466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 67%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kofi Adutwum
20
Reputation points
commented 2024-05-23T17:38:32.9066667+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
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…
asked 2024-05-14T06:10:02.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 79%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Aravind
20
Reputation points
commented 2024-05-23T16:51:12.9166667+00:00
ShaikMaheer-MSFT
38,291
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 57.99999999999999%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
How to establish connections of azure data factory connectivity with AWS dynamo DB
How to establish connections of azure data factory connectivity with AWS dynamo DB - provide a Micrsoft Documentation so that we can follow that to establish the connectivity in between the Azure as well as the AWS platform.
asked 2024-05-22T07:10:18.7466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 18%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Aratrika Bose
0
Reputation points
commented 2024-05-23T08:09:07.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
6,885
Reputation points Microsoft Vendor