Check SQL Server license in SQL Server
As a SQL Server DBA, I would rephrase the statement as follows:…
How to Identify and Store Long Running Queries in a Table
Scenario How to Identify and Store Currently Long Running Queries in a…
How to backup a TDE protected database on Azure SQL Managed Instance
We can take a COPY_ONLY backup of a TDE-protected (encryption enabled) database…
TempDB files recommendation in SQL Server
The number of tempdb data files in an SQL Server depends on…
Find All Permissions for All Users in SQL
We recently encountered an issue with one of our users being denied…
How to change SQL Server instance name
Scenario Troubleshooting host name changes. When the machine name is changed where…
SQL server database in SUSPECT MODE
Scenario A database in SUSPECT mode is one that is not fully…
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…