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
415 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
252 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
531 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
1270 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
503 views 13:31 0 Comments