5,795 questions with Azure SQL Database tags

Sort by: Updated
0 answers

All my resources within my resource group just went missing

I'm testing some stuff within my Visual Studio Enterprise subscription and created a resource group with quite a lot of resources (SQL DB, SQL Server, Azure Function app, Application Insights..). However, today I noticed that now all of these resources…

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,157 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,013 questions
asked 2024-11-21T21:47:12.2166667+00:00
Sven Deha 0 Reputation points
commented 2024-11-22T00:24:46.3666667+00:00
Oury Ba-MSFT 19,571 Reputation points Microsoft Employee
4 answers

Cannot bulk load file from Azure Storage Account

As of the early hours of this morning, I can no longer load files from Azure Storage Account containers using the following code in either of the Azure SQL Databases I've created. I may have missed something, but I don't believe anything has changed to…

Azure SQL Database
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,244 questions
asked 2024-11-19T20:04:22.8233333+00:00
Jez Walters 55 Reputation points
commented 2024-11-21T23:03:24.3833333+00:00
bradley hampson 6 Reputation points
1 answer

Migration_Azure

I have migrated the data from SQL server to Azure SQL Database. The size on the SQL dataset was around 250 mb but on migration when i checked the size it is around 500 mb. I would like to know the reason and how can i cross check that

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.
14,061 questions
asked 2024-11-21T04:04:53.5+00:00
Prateek Hiremath 0 Reputation points
commented 2024-11-21T22:30:27.3233333+00:00
Erland Sommarskog 112.8K Reputation points MVP
2 answers

Azure elastic agent jobs that work for existing databses are failing for newly created one's with "The server principal "ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3" is not able to access the database "

Azure elastic agent jobs that work for existing databases are failing for newly created one's with "The server principal "ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3" is not able to access the…

Azure SQL Database
asked 2024-11-18T16:47:25.14+00:00
Andrew Betts 0 Reputation points
commented 2024-11-21T21:51:42.4666667+00:00
Mahesh Kurva 975 Reputation points Microsoft Vendor
1 answer

Azure Sql database General Purpose: Gen5, 2 vCores pricing getting more from sept 2024 why?

Azure Sql database General Purpose: Gen5, 2 vCores pricing getting more from sept 2024 why?

Azure SQL Database
asked 2024-10-10T11:55:00.59+00:00
amreddy 0 Reputation points
edited the question 2024-11-21T20:50:25.09+00:00
Pavan Minukuri 520 Reputation points Microsoft Vendor
1 answer

What is the GUID that gets created on Azure data sync objects

We have azure data sync setup for on-prem and azure sql db. When Initial trigger is started, there are Data sync tables, procedures and user types gets created.We notice the naming format for procedure is <table_name>_dss_bulkinsert<GUID>…

Azure SQL Database
asked 2024-11-15T15:39:51.41+00:00
Aparna Manoharan 20 Reputation points
commented 2024-11-21T18:39:21.9033333+00:00
Mahesh Kurva 975 Reputation points Microsoft Vendor
1 answer

Azure MI Linked Server

Hi Team, I want to create linked server in Azure Managed Instance using Microsoft OLEDB driver, but I am unable to do the same so can you please help me with that if there is any way where we can do that. Or is there any other solution to connect Azure…

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.
14,061 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,958 questions
asked 2024-11-21T10:43:38.2166667+00:00
Prateek Hiremath 0 Reputation points
answered 2024-11-21T12:16:51.6933333+00:00
Sai Raghunadh M 1,125 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

What dont I see the "Convert to Standby" on a Geo Replication setup of Azure SQL

I have an Azure SQL server and have setup geo-replication for the databases on that server. Since we are only going to be using the replica for DR purposes, we want to switch it from geo-replica to standby-replica. According to…

Azure SQL Database
asked 2024-11-18T07:30:21.6066667+00:00
Mulla, Tabrez 20 Reputation points
accepted 2024-11-21T10:22:07.45+00:00
Mulla, Tabrez 20 Reputation points
1 answer

Azure SQL Serverless DB resuming and pausing automatically

Hi All, We have created an Azure SQL serverless DB, which acts as a backup of our Azure SQL DB and hence after creation, no activity or logins happen in this serverless DB. After creation, we are pausing the DB but it is getting resumed automatically…

Azure SQL Database
asked 2024-11-21T08:11:36.5566667+00:00
Priya Jha 871 Reputation points
edited an answer 2024-11-21T09:35:48.7066667+00:00
Sai Raghunadh M 1,125 Reputation points Microsoft Vendor
1 answer

Azure sql serverless database status showing pause state on azure portal.

i can connect to my Azure SQL Database through SSMS or Azure Data Studio and execute queries while the Azure Portal still shows the database in a "paused" state but queries are executing through SSMS or Azure Data Studio also through my web…

Azure SQL Database
asked 2024-11-14T13:12:26.95+00:00
Abhishek Jadhav 40 Reputation points
commented 2024-11-21T08:59:23.36+00:00
Vijayalaxmi Kattimani 490 Reputation points Microsoft Vendor
1 answer

How to avoid database comparison between on-prem and azure sql after database restore

We have existing Azure data sync setup (in dev ,test and prod) between on-prem and azure sql . As part of data refresh activity, lower env (dev and test) db will be refreshed (delete and recreate db) with prod data along with data sync objects in both…

Azure SQL Database
asked 2024-11-13T10:54:21.4266667+00:00
Aparna Manoharan 20 Reputation points
commented 2024-11-21T08:47:35.92+00:00
Vijayalaxmi Kattimani 490 Reputation points Microsoft Vendor
2 answers

Azure managed instance backup encrypted database

How to backup Azure managed instance database that is TDE encryption enabled

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,943 questions
asked 2024-11-13T21:19:07.77+00:00
Jaime Maccou 0 Reputation points
edited the question 2024-11-21T04:39:26.7233333+00:00
ShaktiSingh-MSFT 15,766 Reputation points
1 answer One of the answers was accepted by the question author.

partition by

Hi, how to add partition by in below table where there is no date key or duration..please give example here is example of sample data customerid - 1 product - grains productcategory-rice sales- 1000

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.
14,061 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,661 questions
asked 2024-11-20T20:43:21.9033333+00:00
Vineet S 1,230 Reputation points
accepted 2024-11-21T02:14:32.33+00:00
Vineet S 1,230 Reputation points
1 answer

ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider

I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,600 questions
asked 2024-11-12T13:59:46.06+00:00
Teresa Thomas 1 Reputation point
commented 2024-11-21T01:57:38.74+00:00
Mahesh Kurva 975 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

cluster Index

if we have large amount of data and customer id would be unique key and product and product and price and billons of data how cluster Index is doing in memory operation? and helpful would be non cluster Index here is example of sample data customerid…

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.
14,061 questions
asked 2024-11-20T20:00:21.6333333+00:00
Vineet S 1,230 Reputation points
accepted 2024-11-21T01:40:56.51+00:00
Vineet S 1,230 Reputation points
1 answer

In Azure SQL Pool we have metrics like Failed Connections : System Errors and Failed Connections : User Errors, but how can we find out what exactly was the error?

In Azure SQL Pool we have metrics like Failed Connections : System Errors and Failed Connections : User Errors, but how can we find out what exactly was the error? How to find out which session was impacted and what error was associated with which…

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.
5,012 questions
asked 2024-11-19T14:21:48.5+00:00
Nilesh Shrimant 0 Reputation points Microsoft Employee
commented 2024-11-21T00:46:07.39+00:00
Sai Raghunadh M 1,125 Reputation points Microsoft Vendor
1 answer

How to create DB for Reservation

I have a reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5 Could you please share with me instructions on how to create DB suitable for my reservation As I understand if I create DB correctly it will link to the…

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.
14,061 questions
asked 2024-11-20T18:06:39.1+00:00
Easy Drive 0 Reputation points
edited the question 2024-11-20T21:22:58.1433333+00:00
VarunTha 9,420 Reputation points Microsoft Vendor
0 answers

How to fix "Selected user account does not exist in tenant 'Microsoft Services'" when using Microsoft Entra to access Azure SQL Server?

I'm encountering the following error when trying to access my Azure SQL Server using Microsoft Entra: Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application '04b07795-8ddb-461a-bbee-02f9e1bf7b46' in that…

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,269 questions
asked 2024-11-07T16:49:33.31+00:00
Ryan M 0 Reputation points
commented 2024-11-20T17:37:19.76+00:00
Raja Pothuraju 8,265 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

How to copy all tables of a Schema to .csv file format in respective folders

Hi, I am trying to copy all tables of Schema-SALES from SQL Server to .csv file format in ADF and files of each table must copy in respetive folder for example. source (SQL SERVER Tables) SALES.Customer SALES. Address …

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,157 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.
5,012 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,911 questions
asked 2023-12-22T21:18:17.5066667+00:00
Zaeemul Haque 45 Reputation points
commented 2024-11-20T15:37:53.82+00:00
Wenrong Xu 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to publish a blazor website with sql sever that is giving the error HTTP Error 500.30 - ASP.NET Core app failed to start

hi, im trying to publish my blazor web app on azure however it fives me the error HTTP Error 500.30 - ASP.NET Core app failed to start. when i try to debug it and go into the diagnose page of the websever i get this error…

Azure SQL Database
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,604 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,269 questions
asked 2024-11-18T11:43:25.1633333+00:00
Aidan Waterford 20 Reputation points
commented 2024-11-20T11:06:03.3933333+00:00
Aidan Waterford 20 Reputation points