Skip to content

Nadeem Asrar's Database Journal

Tips, tricks and opinions on database technology and industry trends!
  • Home
  • About Me
  • Books to Read
  • Contact Me
  • My Blog

Different Database Backup Methods

November 4, 2019 Nadeem Asrar Leave a comment

Physical Backups: – Copies of physical database files or binaries – Two ways to perform physical backup:    (A)- PostgreSQL…

Continue Reading →

Posted in: Uncategorized

Redshift DBA Interview…

October 11, 2019 Nadeem Asrar 1 Comment

Continue Reading →

Posted in: Career, DBA, Interview, Job, Redshift Filed under: Nadeem Asrar, Redshift

PostgreSQL – 2 Simple ways to tell if you are on a streaming replica or a master db?

August 29, 2019 Nadeem Asrar 1 Comment

Issue the pg_lscluster command against the cluster of concern, if it is a replica and not a master, under “status”…

Continue Reading →

Posted in: Database Administration, Database Management, PostgreSQL Filed under: Nadeem Asrar, PostgreSQL, Streaming Replication

pg_basebackup erroring with SSL SYSCALL error

July 25, 2019 Nadeem Asrar Leave a comment

Continue Reading →

Posted in: Database Administration, PostgreSQL, Replication Filed under: pg_basebackup

Execute PostgreSQL commands from Bash

March 17, 2019 Nadeem Asrar Leave a comment

Continue Reading →

Posted in: Database Administration, Linux, PostgreSQL, Unix Filed under: bash, Nadeem Asrar, PostgreSQL

Find all files with a specific text pattern on Unix based system

February 12, 2019 Nadeem Asrar Leave a comment

Finding text patterns in a given file is somewhat easy but what if you just quickly wanted to find all…

Continue Reading →

Posted in: bash, grep, Linux, Unix Filed under: Administration, DBA, Linux, Pattern, Search, SysAdmin, Unix

Technical screening interview questions for a DBA

January 16, 2019 Nadeem Asrar Leave a comment

Below are some DBA Technical Screening questions.  Most of the ones listed below are applicable to MySQL DBAs: Question 1:  How many masters can a replication slave database host…

Continue Reading →

Posted in: Career, Database Administration, Database Management, DBA, MySQL, Nadeem Asrar, Uncategorized Filed under: Career, Database Administration, DBA, Interview, Job, Jobs, Screening

DBMS of the Year

Nadeem Asrar Leave a comment

Continue Reading →

Posted in: Database Management, MySQL, PostgreSQL Filed under: DBMS, Most Popular, Open-source, PostgreSQL

Austin Texas – Tech City?

December 14, 2018 Nadeem Asrar Leave a comment

Austin had made it to the list of the top few cities that Amazon had been looking at getting its…

Continue Reading →

Posted in: Apple Inc., Austin, Career, Resideo, Texas Filed under: Austin, City, Hi-Tech, Jobs, Technology, Texas, Trends

The DBA role today has morphed into a multi-talented Database Professional

December 12, 2018 Nadeem Asrar Leave a comment

Database Professional may be the more apt term for a DBA these days. It sure seems to have become the…

Continue Reading →

Posted in: Career, Database Management, DBA Filed under: Career, Database Management, DBA, Nadeem Asrar

Post navigation

Page 1 of 2
1 2 Next →
Copyright © 2021 Nadeem Asrar's Database Journal