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 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 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
This article guides, How to resolve ,The log for database ‘TestHA’ cannot be shrunk until all secondary’s have moved past the point where the log was added. How synchronizations works in SQL Server AlwaysON? In SQL Server alwaysON, there are at least 1 or more nodes are part of it. Whenever any data change like … Read more
This Article is about , How to find cause of SQL Server cluster failover or SQL restart? | Find AlwaysOn failover reason from SQL Server logs? Why SQL Server restarted or failover in AlwaysON or SQL Server Cluster? There are planned or unplanned outage in SQL Server. Common causes are SQL Service restart, Server reboot, … Read more
This article some best practices about How to perform Index maintenance of large tables in availability groups? OR Index maintenance in availability groups for 10 TB Database What is index in SQL Server? Index is an object in SQL Server database which can be used to retrieve data faster and improve query performance. Mainly there … Read more
This Article help , How to resolve Report server URL was not working? or Fix rsCannotValidateEncryptedData error What is SSRS? SQL Server Reporting Services are getting used to create various type of reports from database or data warehouse. This reports are useful to identify various trends, business metrics etc. This reports can be accessed from … Read more
This article guide, How to resolve, Availability Group database stuck in Not Synchronizing or Database is not coming in restoring mode post removing it from AG group Why this issue occurred? Database size was 5+ TB of one of the database on SQL Server. Index jobs runs weekly. Due to index maintenance job , log … Read more
This article help to resolve, Data file is not shrinking in SQL Server | DBCC ShrinkFile doesn’t shrink file You can follow the steps and check which best solution work for your case. What is issue? or Why Data file is not shrinking in SQL Server or DBCC ShrinkFile doesn’t shrink file Database size was … Read more