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

Month: December 2018

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

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

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