Blog Elevate Your PostgreSQL Skills: The Ultimate Guide to Database Administration Certification Read More » Monitor Database Server using Prometheus & Grafana Read More » How to Test Disk Throughput on Linux using shell script Read More » Linux Command List most used by Database Administrator (DBA) Read More » Automate Postgresql Daily Database Backup using Pgbackreast and bash Read More » How to Take PostgGreSQL Database Backup on AWS S3 bucket using PGBackRest ? Read More » How to Take Full Database Backup using PGBackRest Read More » What is the pgbackrest in PostGreSQL? Read More » How to start PostgreSQL on Windows Read More » How to Configure SSL on PostgreSQL Read More » RPA (Robotic Process Automation) for Database Administartor (DBA) Read More » How to Become an Efficient, Prompt and Successful Database Administrator (DBA) Read More » How to Start and Stop the PostgreSQL Database Read More » awscli Command to Find PostgreSQL rds Free and Used Space Read More » How to Resize PostgreSQL rds Disk Size Using awscli commands Read More » Are Database Administrators in Demand ? Read More » How Database Index Works? Read More » How Database Works? Read More » Copy Table From one PostgreSQL RDS to Another using Python Boto3 Read More » Nextcloud Docker compose Read More » MySQL Isolation Levels with Examples Read More » CAP Theorem Read More » ACID Properties of Database Read More » How Does Data Normalization Improve the Performance of Relational Databases Read More » How to Setup Logical Replication PostgreSQL ? Read More » Migrate PostgreSQL From Cantos to Rocky Linux ? Read More » Redis Docker Compose with a Persistent Volume Read More » Python Script to Check PostgreSQL Database Running Status? Read More » What is the Kubernetes Operator For Database? Read More » Prometheus and Grafana Docker Compose Read More » How to ssh a Remote Linux Server? Read More » Upgrade MySQL 5.7 to 8 on Docker Read More » Docker Compose For ELK Stack Read More » 10 New job Transformation For Database Admin in 2023 Read More » How to send PostgreSQL Logs to Elasticsearch Read More » How to Build Application and MySQL RDS using Terraform Read More » Delayed Replica set in MySQL Read More » MySQL Binlog Read More » I am running one query and it’s taking a long time to run, indexes are in place but not sure whether that indexes are utilized or not. How will you start to troubleshoot that issue? what are you going to check to Resolve that issue? Read More » How can You Troubleshoot Query Performance? Read More » What is Deadlock in MySQL? Read More » What is MySQL Replication ? Read More » What is MySQL ? Read More » Find String and Remove the Line which contains that String using shell Read More » mysqldump With Remote Host Read More » NetSuite Oracle Read More » MariaDB Free ? Read More » Deploy MongoDB on Kubernetes Read More » MySQL New Database Read More » MySQL Query Output in HTML Read More » dbms_metadata in Oracle DB Read More » What is ProxySQL? Read More » Run Pgadmin on Docker Compose Read More » Python Script to Monitor MongoDB Read More » How to Install Brew on Mac Read More » What is PgBench and How to use it ? Read More » Git Commands For DBA Read More » What is Baremetal? Read More » Switchover From Master to Slave in MySQL Read More » What is the Transaction ID Wraparound in Postgres Read More » Explain Plan Options in PostgreSQL Read More » Create PostgreSQL from Azure CLI Read More » Azure data studio PostgreSQL Read More » Migrate MSsql (SQL-Server) to PostgreSQL Read More » How to Check Running status of PostgreSQL on MAC? Read More » How to Check Running status of PostgreSQL on Windows ? Read More » How to Check PostgreSQL Running Status on Linux Server? Read More » PostgreSQL Insert Read More » Heroku PostgreSQL Read More » What is Virtualization? Read More » What is Linux? Read More » How to Configure Foreign Data Wrapper in PostgreSQL Read More » Docker Compose For Elasticserach with Persistent Volume Read More » Backup Elasticserach From shell script Read More » Insert JSON Data File into PostgreSQL using Python Script Read More » Create Insert SQL File with 100 Records From Python faker Read More » Create Insert SQL File with Python Facker Read More » Python Script to Copy only Changed Files From one Dir to Another Read More » Python Script to Copy Files and Directory From one Folder to Another Folder Read More » Jenkins Pipeline to Build rds MySQL Read More » Jenkins Pipeline Script For SQL File Execution on PostgreSQL Read More » Jenkins Job to Execute SQL File From git Read More » Jenkins Pipeline for PostgreSQL Database Backup Read More » Docker PostgreSQL Backup Read More » PostgreSQL Docker Image Read More » Oracle Docker Compose with Persistent Volume Read More » PostgreSQL Docker Compose with Persistent Volume Read More » MongoDB Realm Read More » MongoDB Distinct Read More » MongoDB Atlas Pricing Read More » Comparing DBA, DBRE, and SRE Roles Read More » Who is Database Reliability Engineer ? Read More » Devops will Replace DBA (Database Administrator) ? Read More » Gitops Tools Read More » Flux Gitops Read More » Gitops vs Devops Read More » aks MySQL Server yaml Read More » PostgreSQL vs MySQL Read More » MySQL Distinct Read More » Is MySQL Free? Read More » Best SQL IDEs or SQL Writing Tools Read More » How to write complex SQL Queries ? Read More » What is ER (Entity Relationship) Diagram ? Read More » Migrate oracle db to MongoDB using ETL Read More » Data Pipeline From Oracle to MongoDB using Python Read More » Data Pipeline From Oracle to PostgreSQL using Python Read More » Data pipeline from MySQL to PostgreSQL using Python Read More » Bash Script for Data Pipeline Read More » What is Data Pipeline? Read More » aws Pricing Calculator Read More » How to Execute SQL File on MySQL RDS using awscli Read More » Add space to aws MySQL RDS using awscli Read More » Clone MySQL RDS snapshot using awscli Read More » Basic Docker Compose Commands Read More » What is Docker? Read More » What is Docker Compose? Read More » How to Clone RDS Postgresql snapshot to new Database Read More » Python script to take MySQL Database Backup Read More » Shell Script to Take MySQL Backup Read More » MySQL Table Backup Read More » MySQL Database Backup Steps Read More » Clone Database using pg_basebackup Read More » PostgreSQL Clone Database – pg_dump Read More » max_parallel_workers_per_gather Read More » PostgreSQL citus (Hyperscale) Read More » postgres now() Read More » Percona PostgreSQL Read More » Migrate PostgreSQL Database to Digital Ocean Read More » Digital ocean PostgreSQL Read More » Google GCP PostgreSQL Read More » Elasticsearch PostgreSQL Read More » Amazon Redshift PostgreSQL Read More » pgbadger PostgreSQL Read More » airflow PostgreSQL Read More » pgtune Postgresql Read More » PostgreSQL List Databases Read More » Rebuild PostgreSQL slave from Master Read More » Rebuild a MySQL slave from Master Read More » PostgreSQL Query Tuning Tips Read More » How to Tune PostgreSQL Database Read More » Delete Duplicate Recrors From Postgresql Tables Read More » PostgreSQL Vacuum Read More » Coalescence PostgreSQL Read More » PostgreSQL port Read More » What is git Cherry Pick ? Read More » steps to build backup Jenkins node Read More » Shell script to Import csv to PostgreSQL Read More » How to Convert csv to PostgreSQL Insert statement Read More » What is the ora2pg? Read More » Oracle to PostgreSQL Migration using orafce Extension Read More » MySQL to PostgreSQL Migration Read More » Python Script to Take PostgreSQL Backup Read More » PostgreSQL Backup Using Bash Script Read More » Fake Data Generator For MySQL Read More » Create AWS EC2 From AWS CLI with Public IP Read More » How to Take PostgreSQL Schema Backup Read More » How to Fix Pg_ctl command not found Read More » HA Proxy For MySQL Master – Slave Read More » How to Rebuild MongoDB Replica-Set Node Fast in Few Minutes Read More » Free Database Client For PostGresql Read More » Essential AWS Services for Database Administrators to Learn Read More » Running MongoDB on Docker Compose Read More » How to Fix Cannot open your terminal ‘/dev/pts/2’ – please check Read More » How to fix Rocky Linux full screen issue on Oracle Virtual Box Read More » MySQL query output to csv Read More » Take MySQL backup From Jenkins Job Read More » Apache Tomcat: java.net.BindException: Permission denied (Bind failed) :443 Read More » How to Configure Oracle Transparent Data Encryption (TDE) on Standby Database Read More » How to fix ORA-28368: cannot auto-create wallet Read More » AWS Services and their Azure alternatives Read More » How to Manage AWS S3 Bucket with AWS CLI Read More » How to connect PostgreSQL Database from PgAdmin Read More » How to create AWS RDS PostgreSQL Database Read More » Convert pem to ppk Read More » How to Install PuTTy on Windows Read More » How to Install and create AWS EC2 Instance using Terraform Read More » AWS MySQL RDS Database Creation using AWSCLI Read More » How to Create MySQL Database with AWS RDS Read More » How to connect to AWS MySQL / MariaDB RDS or EC2 database from MySQL WorkBench Read More » How to Change Apps and SYSADMIN Password in EBS R12.1.x Read More » How to Become Oracle apps DBA ? Read More » What does DBA mean? Read More » 150 Oracle DBA Interview Questions Read More » How to fix WARNING: UNPROTECTED PRIVATE KEY FILE! Read More » List of 100 MySQL Interview Questions Read More » Delayed replica set Member in MongoDB Read More » Top 5 Future Technologies for Database Administrators (DBA) to learn in 2022 Read More » How to Loop in Bash | Linux /Shell Script | Automation Read More » How to take a Screenshot on Windows | Ways to capture your screen Read More » Top 5 Software Technology Trends in 2020 List Read More » How to create Linux/RHEL8 machine on AWS (Amazon Web Services) using EC2 service Read More » How to fix centos full screen issue in Oracle VirtualBox Read More » How to setup Network between Oracle VirtualBox and Virtual machine on Window/Mac iOS Read More »
Elevate Your PostgreSQL Skills: The Ultimate Guide to Database Administration Certification Read More »
I am running one query and it’s taking a long time to run, indexes are in place but not sure whether that indexes are utilized or not. How will you start to troubleshoot that issue? what are you going to check to Resolve that issue? Read More »