How to restore Azure SQL Database from one SQL Server to a new SQL Server
I am trying to restore an existing Azure SQL Database hosted on Azure SQL Server to a new Azure SQL Server hosted on a different resource group. So far, I figured the best possible method to accomplish this is by creating a BACPAC file using SSMS. Now…
Azure SQL Database
Azure SQL vulnerability assessments should run weekly (configured on subscription level with express configuration), but some databases are scanned monthly.
Azure SQL vulnerability assessments should run weekly (configured on subscription level with express configuration), but some databases are scanned monthly. The weekly vulnerabiilty reports randomly show databases. In my case, I have 5 databases, and the…
Azure SQL Database
Azure Database Watcher for Read Scale-Out
Hello, We have set up Database Watcher for Azure SQL Database on Premium Tier with Read Scale-Out feature enabled. We have set up our database as SQL target with Read intent flag enabled. We would like to see the read-only replica as a separate…
Azure SQL Database
Why am I seeing around $380 in charges for an Azure SQL Database even though it was created using the Free (serverless) tier and barely used?
We created an Azure SQL Database using the Free serverless option since it was intended only for basic testing. There was no significant workload, very little data, and almost no CPU activity. However, when we reviewed Cost Analysis, we noticed charges…
Azure SQL Database
Urgent - unable to restore snapshot mysql flexible server 'No available SKUs in this location'
I'm trying to restore a point in time backup of a mysql server. If I attempt via AZ cli I get 'No available SKUs in this location'. Trying via the portal I get 'Provisioning is restricted in this region. Please choose a different region. For exceptions…
Azure SQL Database
Update-AzSqlInstanceVulnerabilityAssessmentSetting error
Hello, I am having some trouble with this cmdlet Update-AzSqlInstanceVulnerabilityAssessmentSetting when configuring vulnerability assessment for a Azure SQL Managed Instance. For context I have a User-assigned Managed Identity set as primary identity…
Azure SQL Database
DR for DWH solution
Hello, I need to pick up some input what type of DR I need to use for a Data Warehouse build on Azure. Here's the setup: Data Source -Oracle OCI (cloud) ETL tool - Synapse Pipelines Data Lake gen 2 used to store data as is taken from Oracle db…
Azure SQL Database
Azure SQL serverless costs are high despite low usage – is this configuration oversized and what is a safe lower tier?
We are seeing steadily increasing Azure costs, with the majority of spend coming from an Azure SQL Database. The current configuration is General Purpose serverless, Gen5, 6 vCores, 250 GB max storage. Actual usage is very low: storage averages 2–3 GB,…
Azure SQL Database
Azure Managed Instance - Shrink 32TB database that has 20TB free space
Good Day I have a 32TB database in an Azure Managed Instance. The database after a cleanup now has 20TB free space. The database has multiple files. I've been trying to shrink the database by running DBCC ShrinkFile on individual files. The command ran…
Azure SQL Database
How do I restore a SQL Server. (The resource group is also deleted)
Azure SQL logical server AND its resource group were accidentally deleted. How do i restore the SQL Server
Azure SQL Database
Agent message code 21118. Failed to connect to Azure Storage '\\filestorage.file.core.windows.net\replshare' with OS error: 67.
We are trying to mount Aure file storage account file share with SQL Managed instance and getting below error: -XCancelEventHandle Global\Distribution-{999CD062-8A3C-4697-9A2A-B241BB5852ED} 2026-01-15 08:28:21.258 Startup Delay: 2800…
Azure SQL Database
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
Developer technologies | Transact-SQL
Developer technologies | Visual Studio | Other
SQL Server | Other
Service Principal permissions needed for OPENROWSET queries to Azure Blob Storage via Fabric
Description: I'm querying Microsoft Fabric from Python using pyodbc and SQLAlchemy with ActiveDirectoryServicePrincipal authentication. What works: Querying tables in our mirrored PostgreSQL database executes successfully with the service…
Azure SQL Database
How do I Fix Login failed for user ''. for Mac apple silicon download azure SQL Server
've been trying to install azure sql for the past 3 weeks and eep getettign this error message. I deep dived the web for answers but none have suffice. Can you help, I'm trying to use sql for my class and business. I know it's telling em the username I…
Azure SQL Database
How to load data from azure file share to SQL managed instance?
How to load files (image, Microsoft document, pdf, etc.) in azure file share to SQL managed instance?
Azure SQL Database
Azure Logic App - SQL Stored Procedure Execution Failing with 403 Forbidden Despite Correct Permissions
I have an Azure Logic App configured to interact with an Azure SQL Database. The app successfully: Inserts data into a table Uses the same SQL connection However, when attempting to execute a stored procedure, I receive a persistent 403 Forbidden…
Azure SQL Database
Azure SQL MI Fail over group configuration freezes?
Hi thanks for the attention of my question I am using Azure SQL MI. I want to configure replication to a secondary region by setting up a fail over group. However, since we are in production, it is important that there are no interruptions (including…
Azure SQL Database
Trying to change region for sql database
trying to move resource/db to east us region. Seems to not allow it. Not sure what to do.
Azure SQL Database
Architecture advice for a Battery Passport SaaS: Integrating Azure SQL Database with Container Apps and API Management.
I am a university student working on a project for a SaaS and Battery Passport solution and I am researching the most optimized and cost-effective Azure architecture for this use case. The company collects and stores data from customers. Using this data,…
Azure SQL Database
Do I need a new SQL Managed Instance?
I’m a data engineer at our company, but our Azure subscription is managed by a separate IT team. We’re building a new data platform and need elevated permissions to manage specific databases, without having full administrative access to the entire…
Azure SQL Database