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 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
This Article guide , How to fix An explicit value for the identity column error? | or Insert statement failed with Error 8101 What is identity column? An identity column, also referred to as an auto-increment column or a sequence, is an integral component of a database table that automatically generates a unique numeric value … Read more
This article about, How to resolve, the server principal owns one or more availability group(s) and cannot be dropped? What is availability group? Availability Groups are a feature in Microsoft SQL Server that provide high-availability and disaster recovery for user databases. They were introduced in SQL Server 2012 as a database-level solution, allowing multiple databases … Read more
This article helps to find Deadlock history or How to get deadlocks history in SQL Server using system_health extended events? Deadlock : refers to a situation where two or more transactions are waiting for each other to release resources, resulting in a state of permanent blocking. This impasse prevents any of the transactions involved from … Read more
This article help to resolve, How to troubleshoot service principal name issue? | The SQL Server Network Interface library could not register the Service Principal Name (SPN) in SQL Server What is SPN? In SQL Server, the Service Principal Name (SPN) is a unique identifier used to associate a service instance with a specific domain … Read more