"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db
I get the following when attempting to use either SHRINKFILE or SHRINKDATABASE: "DBCC SHRINKFILE for data files is not supported in a Hyperscale database when the database is not encrypted or protector change is in progress. Enable transparent…
Azure SQL Database
AzureSQL: Error executing a cross database query on the server with private endpoint
Hello, I'm trying to execute a cross database query on Azure SQLServer with multiple databases and run into error below: Any clue on how to go above resolving this? Msg 46832, Level 16, State 3, Line 93 An error occurred while establishing connection to…
Azure SQL Database
Unexpected costs in Azure Database
Hi Azure community, I recently set up a free tier student account using which I have created a SQLDB in the UAE region. While the cost per month according to documentation says 6 USD, I am being charged around 83 USD. There are no other resources…
Azure SQL Database
How to fix SQL vulnerabilities using baselines?
I have many SQL vulnerabilities in my subscription but when I open them the remediation is very unclear and obscure. It says to add to baseline but I need to know where can I edit the security baseline and what needs to be added/removed from it for each…
Azure SQL Database

Can connect with database using Azure Studio not with ODBC
Please provide the following details to your technical contact: Error Details: The exact error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '******@highlandfarms.net' in Entra ID (Authentication option is…
Azure SQL Database
Cannot connect to Azure SQL server
This morning, we were unable to connect to two of our azure sql servers (UAT and Prod) from an on prem VM, yet we could connect to our 3rd server (DEV). UAT and DEV are on the same subscription in Azure while prod is on a separate sub. Access is…
Azure SQL Database
Our Azure SQL DB looks like it's getting hammered. Very HIGH DTU
Since around 7am this morning a database we use for a simple application has started seeing 100% DTU. I doubled it to 800, but still at 100%. Doubled again to 1600, and still having issues. There's hardly any sessions, so what could be causing this…
Azure SQL Database
Automatic tuning is not creating indexes on our SQL database
We have automatic tuning turned on with Create Index ON, but it no longer creates indexes like it used to.
Azure SQL Database
How to get our database running again
Our free monthly allowance has run out, so I've enabled the 'continue using database for additional charges' however the database is still not accessible. How can I get this running again?
Azure SQL Database

My Sql Managed Instance is stuck in a starting
My SQL Managed Instance seems to be stuck in the starting state.
Azure SQL Database
Unable to Reclaim Allocated Space After Shrinking Azure SQL Database
We are experiencing an issue with reclaiming allocated space from our Azure SQL Database (Pass Service)despite running DBCC SHRINKDATABASE. The database in question (db_name) currently shows approximately 300 GB of used space but over 1 TB of allocated…
Azure SQL Database
Azure Sql performance bad on S3 but not S4
On the 10th of June our Database hosted in UK South started consuming all it's DTUs on a certain query. Usually the database would run at up to 20% DTU, but for an unknown reason it's hitting 100%. I scaled up to S4 from S3 and then the database's DTU…
Azure SQL Database
First Connection to Azure SQL FreeDB takes 60 seconds
I created a new Azure SQL Database using the FreeDB option. It's a serverless solution. The first time I run a web application that accesses it, it takes 60 seconds or more to return a result. After the first page, it is much more responsive. However, if…
Azure SQL Database
SQL managed instance stuck on stage 2 of resizing for 12 hours
Hi. I have an SQL Managed Instance that has been stuck on stage 2 of resizing (I adjusted the disk size) for about 12 hours now. Is there anything I can do?
Azure SQL Database
float value "0.00007136" is stored as "7.136E-05" in azure sql database
I have a table with float column and trying to insert value "0.00007136" but it end up showing as "7.136E-05" I have tried cast float , cast decimal, everything but still it is adding in table like that. I am using simple insert…
Azure SQL Database
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
Enabling user authentication to connect Access front end to Azure SQL Database
I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…
Azure SQL Database
Access Development
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…