RahulError 40926: The operation cannot be performed because the geo-replication link is part of a…Came across with one of the Azure SQL Database scenario where, couldn’t perform a manual failover for Active Geo-Replication from the…Dec 19, 2020Dec 19, 2020
RahulLogin failed for login <Login Name> due to trigger execution.Came across in a situation, where I was not able to connect to SQL Managed instance and the main reason was a trigger which was preventing…Dec 19, 2020Dec 19, 2020
RahulInitiated reboot of PostgreSQL server and it stuck in ‘restarting’ state.I had encountered an issue where due to some reason, I had initiated the reboot of PostgreSQL server, but it never came back. It just…Dec 5, 20201Dec 5, 20201
RahulSQL Server Managed Instance the database got deleted from the Azure portal but it’s still showing…One of my customer’s SQL Managed Instance (MI), has an automation where he was deleting database every night and then restoring it.Nov 16, 2020Nov 16, 2020
RahulHow to create user and logins in Azure SQL PaaS DBHow to create user and logins in Azure SQL PaaS DBOct 31, 2020Oct 31, 2020
RahulSQL MI database properties window getting “Subquery returned more than 1 value” error messageWhile opening the database properties of one SQL MI, getting below following error messageAug 2, 2020Aug 2, 2020
RahulAzure SQL “Scale up and Scale down operation of database stuck”Azure SQL “Scale up and Scale down operation of database stuck”Jul 27, 2020Jul 27, 2020
RahulSQL Server Managed instance error “Cannot open database ‘model_msdb’ version 908.In case if you see the in SQL Server Managed instance error log having the following messages.Jul 27, 2020Jul 27, 2020