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 How to get filenames from Azure blob storage using PowerShell? What is Blob storage? Blob storage or Azure storage is file storage service on Microsoft Azure cloud. We can use this to store various types of file. It supports Blob, file and table. Most common use of azure storage to store file … Read more
This article guides, How to resolve AzCopy common errors? or AzCopy failures troubleshooting What is AzCopy? Microsoft Azure provided cloud storage called azure storage where you can upload or download files from storage. This can be used for many purposes. As DBA most common scenario is to copy file to azure blob storage. Sometime we … 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