How do I update an Azure SQL Database to a newer version of the resource API?
I got this email from Azure Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 You're receiving this email because you use Azure SQL Database APIs. To improve performance and security, we're updating Azure SQL Database…
![](https://techprofile.blob.core.windows.net/images/oUW3afGpxEitEzb3ZBvFIw.png?8D8626)
![](https://techprofile.blob.core.windows.net/images/ttaMfHyLeUqEQr6hK6Judg.png?8DA5B9)
I/O Consumption at 100% after the new release
we recently released a software update where we released a couple of log tables and other things. after the release , the I/O consumption reached at 100% . the perfomance of the website has gone down drastically . there are a lot of read write operation…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Request to Enable PostGIS Extension on Azure PostgreSQL Server
I am hosting a PostgreSQL server on Azure and need to use the PostGIS extension for my project. However, when attempting to install the extension with the azure_pg_admin user, I receive the following error: ERROR: extension "postgis" is not…
How to restore a MABS with the DPMSync
Got some error when im trying to recover a MABS to another computer.what happened is as follow. first i backuped the dpmdb of the MABS to Azure,and we can call this server "M04" secondly i clothed the M04 and move it out of the domain i…
Is CREATE/DROP INDEX Automatic tuning on the Roadmap for SQL managed instances?
Hello, Azure SQL DB's automatic tuning feature is incredibly helpful for us. Is there any plan to bring these features to SQL managed instances in the future? Thank you, Greg
Cosmos database analytical store Vs SQL Database with read replica
Hi Team, I am currently exploring Azure cosmos database and come across the 'Analytical store' feature of cosmos database. I was reading MS documents related to use & benefits of analytical store, but my questions is how it's different than Azure SQL…
Azure Entra ID Authentication fails on Azure APP Services
On Local applicaitons we are able to validate connection Server=tcp:XXXXX.database.windows.net,1433;Initial Catalog=demo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default; Once deployed in azure same…
How to make exclusiv config changes on a managed instance
We want to make a change to the configuration of a DB which seems to be done best when there are no active users/connections to the DB. In our case we want to set READ_COMMITTED_SNAPSHOT to ON We thought of using SINGLE_USER Mode like described here:…
![](https://techprofile.blob.core.windows.net/images/pLgfWYyM0kGnDn4Y5267RA.png?8D8DA3)
how to fix connect timeout while copiying from mysql to azure sql using AZURE DATA FACTORY
I have this error while deploying the task of copiying 5 tables from mysql to azure sql on datafactory Operation on target ForEach_qx9 failed: Activity failed because an inner activity failed; Inner activity name: Copy_qx9, Error:…
I'm not identifying if my account will have problems with the migration on 31 August 2024
Quais serviços clássicos terão problemas com a migração das contas de armazenamento classico que será realizada no dia 31 de agosto. Uso um banco de dados MS SQL, chamadas via HTTP aspx e vbx. Acho incrível eu pagar um serviço que não existe nenhum tipo…
How to identify it is one update operation for table which has enable cdc
We know that we can use change data capture to monitor the data change on sql database table. I tried to run UPDATE TABLENAME SET PKColumn=NewValue where PKColumn=OldValue We can see that there will be one row marking the delete operation and one row…
End of Life reminder: Migrate to Azure Database for MySQL Flexible Server by 16 September 2024 to avoid impact
Hi Support. Per your email dated on 17/5 regarding the EOL for Azuare Database for SQL Single Server after 16-Sep-2024, we would like to clarify : What does it mean by force migrate in a phased manner? Will our existing MySQL Single Server be…
![](https://techprofile.blob.core.windows.net/images/hAFzqf2_AwAAAAAAAAAAAA.png?8DB62B)
source is azure sql server tables are moving from azure adf piplelines but user is refreshing from powerbi showing mentioned error.
source is azure sql server tables are moving from azure adf piplelines but user is refreshing from powerbi showing mentioned error.
Can no longer connect to Azure SQL Database
I have a database client application running on Windows with the option to connect to three separate databases on Azure. Each database has a separate client logon credentials. This client application and databases have been working great for several…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Write Operations on primary database latency issue
I have a Azure SQL database replicated to two regions. As per azure documentation secondary databases are read only. In that case all my write operations will be directed to primary. Will that cause latency issue? because my regions are not closer to…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
changing Entra Admin in SQL server bicep template
I have deployed an Azure SQL server with some Entra Id admin through bicep template: but when i redeploy by changing the entra admin, It is not allowing me to do so it throws an error like the provided adminlogin is not valid. I gone through the…
![](https://techprofile.blob.core.windows.net/images/DFUdJReiskW7xaWenka5lQ.png?8DAE8D)
Storing JSON in Azure SQL Table
How can I store JSON responses received from a web activity within Azure Data Factory in an Azure SQL table? The JSON output contains special characters that need to be preserved in the table. I have tried passing the JSON as a string to the stored…
Configure service account in Azure SQL Server
Good morning, I have an SQL Server running on an Azure Virtual Machine, and I've been tasked with creating a 'Service Account' and configuring the SQL Server services (SQL Server and SQL Server Agent) to use this new account. Currently, my SQL Server is…
ACI needs MS SQL access which is on an azure VM, how do I achieve this?
Hi, I have deployed a container instance which has a connection string which points to a SQL database which is hosted on an azure virtual machine. The virtual machine has its own public IP address. However, the container instance cannot "see"…
Unable to delete Azure SQL DB, logs display Internal Server Error
I recently created a MSSQL server, which I was trying to move to an elastic pool. In between I initiated the deletion of the database, I received the notification for successful deletion, however, the database is still present. I checked the Activity…