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, 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 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
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 is video tutorial on How to write simple SQL queries? or Learn simple SQL queries SQL queries are versatile, and they can be utilized for numerous operations, including creating and modifying tables, inserting, updating, or deleting data from tables, selecting data from one or multiple tables based on specified conditions, joining tables to combine … Read more