Password reset of SQL service account

Impact of resetting password for SQL Server service account Resetting the password of your SQL Server service account is a critical security measure that should not be taken lightly. In…

Read Full
411 views 16:41 0 Comments

How and Why to become a SQL Server DBA?

What is a SQL server dba? A database administrator (DBA) is responsible for the performance, integrity, and security of a database. They may also be involved in the planning and…

Read Full
247 views 18:58 0 Comments

Get CPU Utilization Data from SQL Server

Monitoring the CPU utilization of a SQL Server instance is crucial for maintaining optimal performance and identifying any potential bottlenecks. In this blog post, we will explore how to analyze…

Read Full
480 views 04:42 0 Comments

Migrating SQL Server Database Mail Settings

Migrating SQL Server Database Mail Settings Migrating SQL Server Database Mail profiles, accounts and settings can be a complex and time-consuming process. This article will provide an overview of what…

Read Full
1244 views 03:59 0 Comments

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
496 views 13:31 0 Comments