Use ProcDump to capture sql server unexpected crash dump

To use ProcDump to capture a SQL Server unexpected crash dump, follow these steps: Download and extract ProcDump: Go to the website: https://learn.microsoft.com/en-us/sysinternals/downloads/procdump Download the ZIP file containing the ProcDump.…

Read Full
207 views 12:26 0 Comments

SQL Server DBA Daily Routine Tasks

As a SQL DBA, there are various essential tasks to perform every day to ensure the smooth operation and security of the database system. These responsibilities include: Conducting Regular Backups:…

Read Full
568 views 17:58 0 Comments

All About DBCC and DMV Interview Question 

What is the use of DBCC commands?  DBCC stands for Database Console Commands, a few of us also call it database consistency checker. There are many DBCC commands in SQL Server. We…

Read Full
265 views 11:55 0 Comments

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