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

Category: Database Management

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

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

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

Identify and DELETE duplicate records in PostgreSQL

December 6, 2018 Nadeem Asrar Leave a comment

To avoid having duplicate records where you did not want them, you obviously should have a UNIQUE constraint put in…

Continue Reading →

Posted in: Database Management, Delete Duplicates, MySQL, PostgreSQL, SQL Filed under: Database, De-duplication, Unique

Import/Export CSV files in PostgreSQL

December 3, 2018 Nadeem Asrar Leave a comment

The PostgreSQL COPY command can be used to both import from and export to a CSV file. IMPORT: Import CSV…

Continue Reading →

Posted in: Database Administration, Database Management, export, import, PostgreSQL, SQL Filed under: CSV, Export, howto, Import, Nadeem Asrar, PostgreSQL

Commands to help troubleshoot Redshift SQL Query Performance

November 30, 2018 Nadeem Asrar 1 Comment

Continue Reading →

Posted in: Database Management, Performance, Redshift, SQL Filed under: Database Management, DBA, Nadeem Asrar, Redshift

Recent Posts

  • Different Database Backup Methods
  • Redshift DBA Interview…
  • PostgreSQL – 2 Simple ways to tell if you are on a streaming replica or a master db?

Recent Comments

  • Frank Litvinik on Redshift DBA Interview…
  • Greggupdar on PostgreSQL – 2 Simple ways to tell if you are on a streaming replica or a master db?
  • Nicolas Segundo on Commands to help troubleshoot Redshift SQL Query Performance

Archives

  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
Copyright © 2021 Nadeem Asrar's Database Journal