Azure SQL Database
An Azure relational database service.
5,623 questions
0 answers
Convert Julian dates in Normal date
How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates
asked 2024-09-19T18:36:21.3566667+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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
770
Reputation points
commented 2024-09-19T21:27:08.1166667+00:00
Erland Sommarskog
110.4K
Reputation points MVP
0 answers
Update Split Merge Worker image to pull over VNET
Please update Split Merge worker image and documentation. The image currently does not pull successfully over VNET on ASE. The image has foreign layers that are not reachable through VNET. …
![](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(256, 0%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
1 answer
SSMS cannot connect to azure sql db using Microsoft Entra MFA
I just recently updated ssms to 20.1 and am trying to connect to the azure sql via pt-dw.database.windows.net. When I press the "Connect" button, it takes a long time for the browser window to pop up and allow me to choose which account to use…
asked 2024-06-04T02:45:12.8466667+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, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Ferdinand Tomale
0
Reputation points
commented 2024-09-19T18:55:52.3366667+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(224.00000000000003, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andy Harbert
0
Reputation points
5 answers
One of the answers was accepted by the question author.
How to identify usage of Azure SQL Database 2014-04-01 APIs before retirement
I received a notice about retirement of Azure SQL Database 2014-04-01 APIs, what should I do? How do I identify the resources using the old version? Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 You’re receiving this email…
asked 2023-12-02T00:12:59.2266667+00:00
McDonald, Matthew
186
Reputation points
commented 2024-09-19T18:06:21.2433333+00:00
Mark Fletcher
0
Reputation points
1 answer
Add VM VNET Azure SQL Server Public access virtual network
Hi Team I am working to enable connection to Azure SQL from Azure VM. I tried adding VM virtual network to Azure SQL Server networking but I don't find it in dropdown. Thanks Manzoor
asked 2024-09-19T08:25:29.92+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(208, 12%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Baig, Manzoor SOMACC-BNG-ACC
0
Reputation points
edited a comment 2024-09-19T17:04:30.1166667+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(230.39999999999998, 86%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Akshay kumar Mandha
390
Reputation points Microsoft Vendor
1 answer
Failover for secondary read-only endpoint in SQL failover group
Usecase My team has a SQL failover group set up where we use primary region for read-write workloads. We use secondary region to serve read only workloads. I am exploring options for ensuring data availability when secondary server/region is down. …
asked 2024-09-16T19:03:20.43+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(185.6, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devanshi Patel
0
Reputation points Microsoft Employee
commented 2024-09-19T16:33:08.28+00:00
Devanshi Patel
0
Reputation points Microsoft Employee
1 answer
Disk Space Error and Temp Files Management in Azure PostgreSQL Flexible Server
Environment: Service: Azure Database for PostgreSQL Flexible Server Compute Size: 8 vCores, 64 GB Memory, 512 GiB Premium SSD Storage Issue: Running out of disk space during large query operations. Problem: I am frequently running into disk space…
asked 2024-09-13T08:29:58.5066667+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(217.60000000000002, 40%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOK%3C/text%3E%3C/svg%3E)
Osama Khan
0
Reputation points
answered 2024-09-19T15:58:38.17+00:00
Osama Khan
0
Reputation points
1 answer
How do i connect Azure SQL database to my Next TS codebase?
So I have been making a form in Next TS, that when filled by the user will directly save the data into my azure sql database. Im using prisma ORM along with it to connect it better: //this is my API route to connect my code to my database import {…
asked 2024-08-31T12:35:35.5666667+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(108.80000000000001, 45%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Shreyan Shukla
0
Reputation points
commented 2024-09-19T15:56:26.81+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, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
150
Reputation points Microsoft Vendor
1 answer
maintaining different schemas across environments work seamlessly in the SQL database dacpac deployment, particularly for managing environment-specific configurations?
I have quick question on dacpac deplpyment in Azure sql database deployment will maintaining different schemas across environments work seamlessly in the SQL database, particularly for managing environment-specific configurations? One of the requirement…
asked 2024-09-06T05:49:56.07+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, 45%, 15%)' 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)
Sandeep Kumar
0
Reputation points
commented 2024-09-19T15:27:03.2366667+00:00
Sai Raghunadh M
150
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Does the ODBC Driver 18 for SQL Server (18.4.1.1) support Passkeys
I don't think the ODBC Driver 18 for SQL Server supports passkeys as the browser which pop-ups for interactive Azure Entra ID authentication is Internet Explorer which does not support FIDO2/Passkeys. I believe a similar issue existed for SSMS, but a…
asked 2024-09-19T14:24:44.0733333+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(144, 82%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Lawrence Dwight
16
Reputation points
commented 2024-09-19T14:55:35.9033333+00:00
Lawrence Dwight
16
Reputation points
1 answer
Connecting to Azure SQL database in Power BI desktop
I was trying to add Azure SQL database as data source in Power BI. While connecting to the server I got following error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake.…
asked 2024-09-16T14:42:20.87+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(108.80000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mateusz Maruszczyk
0
Reputation points
commented 2024-09-19T14:52:07.9133333+00:00
Sai Raghunadh M
150
Reputation points Microsoft Vendor
0 answers
Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated). Error code 0xintegrated_windows_auth_not_supported_managed_user
We lost access to Azure SQL from SSMS I'm working on fixing it Azure SQL Server authentication using Microsoft Entra Integrated. Here’s my setup: I have an Azure SQL Server with an active database. Our laptops are connected to Hybrid AD Domain We…
asked 2024-09-11T18:17:00.06+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(28.799999999999997, 53%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Eric Burnett
0
Reputation points
commented 2024-09-19T14:43:22.0866667+00:00
Sai Raghunadh M
150
Reputation points Microsoft Vendor
1 answer
How can we configure a Private End Point in between Azure App Service and SQL Database.
How can we configure a Private End Point between azure app service and sql Database to make sure that traffic is being passed through private end point.
asked 2024-09-16T16:37:09.4466667+00:00
Sai Kiran Maturi
61
Reputation points
commented 2024-09-19T10:22:38.2333333+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
5
Reputation points Microsoft Vendor
1 answer
Set up a pre-sync script
We are using Azure Data Sync to synchronise two databases. Sync groups are set up to run every 30 mins automatically. How to set up a pre-sync script and post-sync script ?
asked 2024-09-16T13:37:40.8+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(249.60000000000002, 87%, 34%)' 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)
Aparna Manoharan
20
Reputation points
commented 2024-09-19T10:03:55.1666667+00:00
Mahesh Kurva
5
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
how to include data while extracting dacpac file
Hi, Requirement - to have ci/cd pipeline for DB deployment when a db changes in dev, pipeline has to deploy it to higher environment. We have chosen dacpac deployment, but as per Microsoft document it might include data which is also limited to…
asked 2024-09-18T02:37:55.79+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(188.79999999999998, 94%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Gnanasoundari
45
Reputation points
accepted 2024-09-19T09:24:46.0066667+00:00
Gnanasoundari
45
Reputation points
1 answer
One of the answers was accepted by the question author.
azure managed grafana connection with private azure resources not working
We are using azure sql vm internally in private network and azure managed grafana on private endpoint. We would like to display data from sql to azure managed grafana. We observed that the connection works only if the sql vm is on public network. How…
asked 2024-09-18T10:34:54.3066667+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(281.6, 91%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aruna Kumbhar
0
Reputation points
accepted 2024-09-19T09:11:59.2966667+00:00
Aruna Kumbhar
0
Reputation points
0 answers
Costs for Elastic job Agents
Hi apart from the cost of the S0 SQL Azure instance, what other costs are associated with running Elastic Agent Jobs? I've looked in the pricing calculator and it doesn't seem to be an option there. Cheers Alex
asked 2024-09-19T09:09:19.9766667+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(284.8, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Alex Palmer
0
Reputation points
asked 2024-09-19T09:09:19.9766667+00:00
Alex Palmer
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Can we create a Elastic job agent using java code ?
Can we create a Elastic job agent using java code ?
asked 2024-09-11T15:24:18.9166667+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, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ayush Shrivastava
100
Reputation points
accepted 2024-09-19T07:45:08.8133333+00:00
Ayush Shrivastava
100
Reputation points
0 answers
Issue running job using Elastic Job Agent in dedicated SQL Pool (User Managed Identity)
I have an Azure SQL Server with a dedicated SQL Pool (probably prior to 2020) and a reporting database. I am trying to run elastic job agent using User Managed Identities (UMI) on all database in this Azure SQL Server. I have set up all the logins,…
asked 2024-09-11T22:08:23.3833333+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(150.4, 45%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kshitij Gurung
0
Reputation points
commented 2024-09-19T04:17:14.4133333+00:00
Kshitij Gurung
0
Reputation points
1 answer
Azure SQL Database
Hello I have a question about something that is happening to me regarding access to SQL Databases When I give a group or a user, after creating the Login in the SQL Server, access to the databases that it contains within that same SQL Server, if I give…
asked 2024-09-18T18:06:43.83+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(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
160
Reputation points
commented 2024-09-18T21:01:11.85+00:00
Oury Ba-MSFT
18,696
Reputation points Microsoft Employee