A SQL Server database can get corrupted or damaged due to sudden application or system shutdown, malware attacks, storage issues, software conflicts, and various other reasons. When the database gets corrupted, you can easily restore the backup database (.bak) file.… Read More »BAK File Corrupt or Unreadable? Solutions to Restore your SQL Database
A failover cluster is a group of independent systems (nodes) that work together to ensure continuous database availability. This failover cluster setup contains multiple nodes that share a common storage system. If any of the nodes fail, the SQL server… Read More »How to Recover MSSQL Database after a Cluster Failover?
It is pretty much straightforward to find database file location in SQL Server. When a database is created in SQL Server, two files are automatically created, a data file and a log file. SQL Server database stores data in these… Read More »How to find database file location in SQL Server
LEAP tech event is an innovation hub where you can meet both industry experts and fresh talent together to explore new technologies and build meaningful connections. You can share your ideas, learn about modern technologies, and connect with experts from… Read More »Exhibit at LEAP Riyadh 2025
After the grand success of the previous edition of LEAP in 2024, LEAP tech event 2025 is ready to explode in Riyadh, Saudi Arabia again from February 9-12, 2025. You can witness an astounding assembly of more than 100,000 tech… Read More »LEAP Tech Event 2025 | Riyadh | Registration
Yes, you have heard and seen correctly. Today, I will share with you a bunch of SQL Jokes & Data Jokes. I hope that it will lighten up your mood. Enjoy the jokes and if you have got some interesting… Read More »SQL Jokes and Data Jokes
To manage SQL Server failover cluster Instances and Always ON availability groups, you will need a Windows server failover cluster (WSFC). Windows Server tool called failover Cluster manager is used to manage Windows Server failover cluster. Using the failover cluster… Read More »How to Manage Failover Cluster Using Command Line
In my previous article in the failover Cluster Instance (FCI) category, I share with you the steps to failover the roles/resources to another node. In this article, we will discuss the steps to add a new node to an existing… Read More »How to Add a Node in SQL Server Failover Cluster
DBA sometimes needs to know the last restart time of the SQL Server Instance. It is a piece of important information that can help DBA/Developers to investigate further why and who restart the SQL Server engine. There are multiple ways… Read More »Multiple Ways to Check the last restart time of SQL Server
There are three different recovery models in SQL Server, Simple, Full, and Bulk-logged. These recovery models define whether to include SQL Server transaction logs in the backup and determine what restore operation can be performed. We will talk about the… Read More »How to check recovery model in SQL Server using a query