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: MySQL

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

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

SQL Commands for setting up MySQL Replication With SSL Encryption

December 1, 2018 Nadeem Asrar Leave a comment

What are the SQL commands to run when setting up SSL replication between master and slave database hosts?  Well, assuming the following: …

Continue Reading →

Posted in: Database Administration, how-to, MySQL, Replication, Security, SSL Filed under: howto, MySQL, Replication setup, SSL

Translating basic commands between mysql vs psql

November 29, 2018 Nadeem Asrar Leave a comment

          mysql … to … psql       Several years back when I was learning PostgreSQL and I…

Continue Reading →

Posted in: Database Administration, MySQL, PostgreSQL, SQL Filed under: MySQL, Nadeem Asrar, PostgreSQL

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