Find the users connected to SQL Server

In a SQL Server environment, it can be useful to monitor the user activity and track who is connected to the databases, from which machine they are connected, when they…

Read Full
479 views 12:47 0 Comments

Identify and Store Active Transactions

Scenario How to Identify and Store Currently Running Queries in a Table? To retrieve information about currently executing requests on a Microsoft SQL Server database, we can use several Dynamic…

Read Full
286 views 11:01 0 Comments

TempDB files recommendation in SQL Server

The number of tempdb data files in an SQL Server depends on several factors, including the number of logical processors on the server. As a general recommendation, it's best to…

Read Full
210 views 08:18 0 Comments

How to change SQL Server instance name

Scenario Troubleshooting host name changes. When the machine name is changed where we have installed SQL Server, all the instances services are started but replication, Jobs, Alerts, Maintenance plans causes…

Read Full
768 views 03:33 0 Comments

How to fix a suspect mode database?

Scenario A database in Suspect mode is one that is not fully operational and may have some form of corruption or problem. If you are experiencing this issue, you will…

Read Full
232 views 05:02 0 Comments