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…
Azure SQL Server
Please Could you help me with the following question: In Azure SQL Servers With which script(s) should a login be created using MFA authentication with T-SQL? Then with which script should the users be created within the databases of said SQL engine and…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Azure SQL Database 2014-04-01 APIs will be retired
Hello, I would like to know where to go to see if the Azure SQL Database is using 2014-04-01 APIs. Please let me know if you need any more info.
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…
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…
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.
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…
How to overcome the Foreign key constraint issues when we configure SQL DB Sync between 2 Azure SQL Databases.
It's common that we use Foreign Keys in SQL Database. So when we configure Sync Groups and trigger a Sync, we face issues due to foreign keys. so that we have sync the tables in sequential order. is it not possible to define the order of tables while we…
![](https://techprofile.blob.core.windows.net/images/kqkl5M5NTkiQI6BbTT6B6w.png?8DB551)
Connection string is not valid [87] when trying to connect to the managed instance through ODBC
Hello, I have an issue connecting to the Azure Managed Instance through OBDC SQL Server Driver 18. The error message is posted below. I was only able to connect using two of the computers, which happen to be used be admins but could connect to it using…
Error connecting to Azure Managed Instance through ODBC
I am unable to connect to the Azure Managed Instance using the OBDC SQL Server Driver 18. The error message says the connection string is not valid [87]. I have tried different ODBC driver versions and changing the TLS version on Azure portal but it did…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
SQL Server
Hello I would like someone to help me with the following problem I am having. From SQL Management Studio. In SQL Server, when I have to create a new Login, when I right-click on the Login folder and select new login, by default it opens the way to create…
Is UniqueIdentifier will be a good choice for Primarykey
Hello, "Is UniqueIdentifier will be a good choice for Primarykey". As I know that Uniqueidentifier identifier comparison will take more time than a number comparison. I can see a lot of issues on Uniqueidentifier. In our projects, most of the…
unable to create sql server. getting like Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another region or
unable to create sql server. getting like Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another region or…
How to log from Azure SQL Database
Is there a way to log messages in Azure SQL database directly ? similar to what we do with any springboot application ? log.error or log.info("your message");
Replicating a Pipeline Multiple Times in Azure Synapse Analytics
How can I replicate a pipeline multiple times in Azure Synapse Analytics? I need to replicate my pipeline 10 times with only a change to the table name which is passed as a parameter. Thanks in advance!
Delete lock prevents editing of IP address in Azure Sql Server firewall
We are unable to edit IP addresses in Azure Sql Server firewall whilst a delete lock is in place. Some of our staff do not have static IP addresses so have to regularly update their IP addresses in the firewall. The only way to do this is to first…