Year: 2022
Checking the Free Space in Data and Log Files in a Database in SQL Server
In a database, data and log files are used to store the…
Checking the Backup Path of a Database in SQL Server
Backing up a database is an important part of any database administrator’s…
How to check the attachment size limit in SQL Database Mail
Overview of Database Mail Are you looking for the quickest and most…
Check permissions given to a database role
As a Database Administrator, you may need to identify the permissions that…
Operating system error 50 in Azure SQL Managed Instance
We encountered an error while taking a backup of a database from…
Password reset of SQL service account
Impact of resetting password for SQL Server service account Resetting the password…
How and Why to become a SQL Server DBA?
How and Why to become a SQL server dba? What is a…
How to find SQL Server running TCP IP port
Finding the SQL Server Port Number Recently we have installed a second…
Get CPU Utilization Data from SQL Server
Get CPU Utilization Data from SQL Server SQL Server is built on…
Driver could not establish a secure connection to SQL Server
Driver could not establish a secure connection to SQL Server Recently windows…
Migrating SQL Server Database Mail Settings
Migrating SQL Server Database Mail Settings Migrating SQL Server Database Mail profiles,…
Checking SQL Server Job History by Script
Checking SQL Server Job History by Script Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains…
Checking Compatibility Level Of All Databases In SQL Server
Checking Compatibility Level Of All Databases In SQL Server SQL Server is…
Oracle DBA Interview Questions
Oracle DBA Interview Questions A. COMPANY- Oracle (OFSS), Location -Bangalore 1. Describe…
Find active transactions by duration
Find active transactions by duration Recently frequently we faced blocking issues on…
Certificate chain issued by authority that is not trusted
Certificate chain issued by authority that is not trusted Recently we moved…
Check the Status of E-Mail Messages Sent With Database Mail
Check the Status of E-Mail Messages Sent With Database Mail In SQL…
Linux Commands frequently used
Linux Commands frequently used Linux is a powerful and versatile operating system,…