Checking SQL Server Job History by Script

Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains all major information regarding the SQL Server job and its running status and history. We may directly query both objects and get the details or…

Read Full
503 views 13:31 0 Comments

Find active transactions by duration

Recently frequently we faced blocking issues on our production server. The main reason that I understand, recently we merged a few SQL servers and migrated all databases to a single…

Read Full
274 views 07:31 0 Comments

Change Default TCP Port in SQL Server

Change Default TCP Port in SQL Server When any version or edition of MSSQL Server is installed, by default it's installed on default port 1433. By default, we need to…

Read Full
280 views 14:34 0 Comments

Find database size when it is offline

Hi, Tech Giants! What new to me today? Yeah, We did a SQL Server migration activity or we can say a side-by-side up-gradation activity. From our DBA side, it's almost…

Read Full
496 views 16:00 2 Comments