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
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
Filegroup in SQL Server is a logical container that is used to group together database data files for the purpose of administration and data allocation. There is a default Primary filegroup with every SQL Server database. Filegroups are not the… Read More »What is filegroup in SQL Server
It is very important to patch your SQL Server instance on a regular basis. It will keep your SQL Server instance up to date and fix the bugs you are facing in your previous patching version. By applying regular SQL… Read More »How to Patch a Standalone SQL Server Instance
Most of the SQL Server DBA and developers use Microsoft SQL Server Management Studio (SSMS) to work with SQL Server databases. It is undoubtedly the most popular tool to manage SQL Server databases. SSMS comes up with many helpful tools… Read More »How to add line numbers in SQL Server Management Studio