This article help to How SQL Server Always ON can help to achieve RPO and RTO? OR Achieve three in One Solution using SQL Server Always ON How Always On in SQL Server works? SQL Server Always On is one of the best high availability method started from SQL Server 2012. This can be used … Read more
This article guide on, How to resolve SQL Server Error 15343? or Troubleshoot, Could not drop login Why Error 15434: Could not drop login as the user is currently logged in coming? When there is task to delete or drop user from SQL Server we have to make sure that no one is connected with … Read more
This article guides on Database recovery is slow due to log file issue in SQL Server Always ON failover? | How to troubleshoot database startup slowness in SQL Server Always ON failover ? What is DB startup in SQL Server? Whenever there is planned or unplanned SQL Server stop or restart , SQL server will … Read more
This article helps, How To Resolve Microsoft SQL Server Error 15401? or Error Could not obtain information about Windows NT group/User error code 0x534 How SQL Server access work with AD groups? As best security practice system admin team create different AD groups for SQL Server database access. Those groups are created based on access … Read more
This article is about, How to resolve SQL query takes 30 min on one server and same will takes 3 hours on another server? or Query slowness due to Maxdop and CPU issues on SQL Server Sometime customer raise ticket that they are facing query slowness issue on one server and same query executing quickly … Read more
This article guide to identify high CPU queries on SQL Server. Sometime as DBA we get alert for high CPU utilization on SQL Server. To start troubleshooting, we need to find out which queries currently taking high CPU time to execute. Below query help to find out high CPU running queries. This query will returns … Read more
This article guides , How to Resolve, Cannot open server ‘testdbserver’ requested by the login for Azure SQL Database or Resolve Client with IP address ” is not allowed to access the Azure SQL server. What is Azure SQL Database? Azure SQL database is pass(platform as Service) offering from Microsoft. You can use Azure SQL … Read more
This article help to resolve, Cannot open database “test” requested by the login. The login failed. Login failed for user ‘ABC\Test’. or Database status is in recovery pending Why we get error Cannot open database “test” requested by the login. The login failed. Login failed for user ‘ABC\Test’ Sometime due to heavy SQL queries or … Read more
This article guides, How to resolve restore error in SQL Server 2022? or Column name or number of supplied values does not match table definition. Why below error occurred? Sometime we get request to restore database from SQL Server 2012 or 2014 to SQL Server 2022 or we have database refresh job on old server … Read more
This Article guides about, How to resolve ,Backup and Restore operations on Block Blobs are not supported when WITH CREDENTIAL syntax is used. What is URL backups in SQL Server? From SQL Server 2012 , we can take SQL database backups on Azure Blob Storage. This backup called URL backup. They are similar like disk … Read more