About in Ms Azure SQL DBA
#azure training what iaas and paas in azure SQL database administrator This question is related to the following Learning Module
Azure SQL Database
Getting an Access Denied error when accessing a file in Azure Blob Storage
Files have been loaded into a blob container, and through PowerShell, that data has been loaded into the Azure SQL database successfully for over 2 years. As of last week, this process was functioning correctly. Currently encountering an Access Denied…
Azure SQL Database
recover deleted sql server
Hello i have deleted the sql server and the sql db and i need to recover them is that possible?
Azure SQL Database
External Data Source from Az SQL DB to Az VM with SQL Server
Hi, Is it possible to create an external data source connection from an Azure SQL Database to SQL server running on an Azure VM. I've created the connection to external server (Azure VM) which creates but when I try to query it, it fails CREATE…
Azure SQL Database
How to provide VIEW SERVER STATE permission to a user in master Azure DB
How to provide Serverstate permission to a user in master Azure DB.
Azure SQL Database
Login Failed for User '
Encountering the error "Login failed for user '
Azure SQL Database
How to Fix:Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].
I followed the documentation: https://learn.microsoft.com/en-us/sql/linux/quickstart-sql-server-containers-azure?view=sql-server-ver16&tabs=kubectl to deploy SQL server on AKS. But While connecting to it, getting the below error: Sqlcmd: Error:…
Azure SQL Database
Azure
Azure Kubernetes Service
SQL Server | Other
Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.
Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.
Azure SQL Database
Data factory fails to run Stored Procedure when SSMS succeeds
I have a nightly job that generates an email via a stored procedure run through azure data factory. It has been in use for about 2 years with no problem. Yesterday it failed without any changes to the SQL A database operation failed with the following…
Azure SQL Database

Can't create a SQL Database server in East US region.
Hello Team, We would like to create a SQL Database server in East US region. But we see the following error - "Your subscription does not have access to create a server in the selected region. For the latest information about region…
Azure SQL Database
Azure SQL database charges keep climbing while db is paused
Hello, I've observed that my Azure SQL database continues to accrue charges even when it is in a paused state. To clarify the current setup: The only service that connects to the database is an App Service hosting a Web API, which is currently…
Azure SQL Database
Azure Database unable to update Datasync config & Datastudio timeout
We seem to be having 2x issues with an Azure SQL database. Datasync keeps failing sync data & reconfiguring of tables to sync. The database is timing out populating the tree of table in both SQL Management Studio & Azure Data Studio. The…
Azure SQL Database
Reconnect Issues in SSMS to Azure SQL DB with Microsoft Entra MFA After Role Reactivation
Connecting to Azure SQL DB with Microsoft Entra MFA from SSMS was successful previously. However, after the role assignment to the Privileged Identity Management Group expired and was re-activated, reconnection from the same SSMS instance fails to invoke…
Azure SQL Database
Disaster Recovery Plan | How to Restore Azure SQL Database from One Resource Group to Another Across Regions
Hi Team, We recently encountered a limitation while trying to restore an Azure SQL Database from a source server in one resource group to a new SQL Server in another resource group (across regions) using Point-in-Time Restore. Scenario: We have an…
Azure SQL Database
Azure, Export Hyperscale Database to BacPac failed due to Vector datatype column in a table.
Trying to export a Hyperscale SQL database to Blob storage BacPac. I did som laborations with VECTOR datatype in one table an left it there for later laborations. The export fails due to the Vector column. ErrorMessage: "The ImportExport…
Azure SQL Database
What are the cost impact of increasing storage for databases in Azure SQL Elastic Pool
We’re using Azure SQL Databases in an Elastic Pool configuration with General Purpose: Standard-series (Gen5), 6 vCores, and I’m trying to understand how the cost is calculated for the elastic pool, especially regarding storage usage. My current…
Azure SQL Database
Azure SQL Managed Instance - A disconnect event was raised when server is waiting for Federated Authentication token
We are running Production workloads on Azure SQL Managed Instance, and periodically we see errors: A disconnect event was raised when server is waiting for Federated Authentication token. This could be due to client close or server timeout…
Azure SQL Database
Cannot see the list of available backups
I need to give one of our members access to see available backup list and give him the ability to restore. However, when he logged into the portal, he sees nothing on the list. This is for Azure Managed SQL instances.
Azure SQL Database
How to connect from an azure VPN to an azure SQL server from my PC?
We want from our work computers using an azure VPN to be able to connect/access the databases we have in azure SQL/MySQL. I have read the documentation but I don't understand how it is possible to do this without having to connect from a virtual machine.…
Azure SQL Database
Azure VPN Gateway
Azure Virtual Network
Azure Database for MySQL
How to resolve the "Incorrect syntax near 'FORMAT'" with Parquet file
I'm working with Azure Sql connected to an Azure Storage account. I want to read a Parquet file from a Azure Storage account. This code works with a CSV, so I know the connection is good, but when I set the Format to Parquet I get Incorrect syntax…