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
You can manually failover the cluster group from one node to another using the failover cluster manager or using PowerShell script. This article will show you the steps to failover a cluster using a failover cluster manager. Below mentioned are… Read More »How to failover Cluster Group from one node to another
The cost threshold for parallelism (CTP) is the cost threshold we define at the Instance/Server level which determines which query will use a parallel execution plan. For each query executed in SQL Server, the optimizer calculates the overall cost for… Read More »What is cost threshold for parallelism in SQL Server