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

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

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

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

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

Post navigation

Page 2 of 2
← Previous 1 2
Copyright © 2021 Nadeem Asrar's Database Journal