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…

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…

Driver could not establish a secure connection to SQL Server Recently windows patching was done on a server and also SQL server security got update with the same patch. Later…

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…

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…

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is a server-based system that can be accessed by multiple users simultaneously. It offers many features, including…

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…

Certificate chain issued by authority that is not trusted Recently we moved whole on-premises resources to the cloud. In an easy word, we have moved SQL Server from on-premises to…

In SQL Server sp_send_dbmail use to send emails and the SQL Server log all the status of each message processed by Database Mail. Below is the quick list of Database…

Introduction As a database administrator, one of the crucial tasks is to ensure regular backups of databases. Monitoring the Database Backups Details including backup status and locations of different types…