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…
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…
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 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 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?
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 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…
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 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 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…
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 managed instance backup encrypted database
How to backup Azure managed instance database that is TDE encryption enabled
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
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…
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…
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…
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…
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…
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 …
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…