--- title: "#dbaguides articles | Hashnode" description: "Explore 14 articles tagged #dbaguides on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/dbaguides" --- Tag # #dbaguides 14 posts · 3 followers [DBA](https://hashnode.com/@dbatevolta) · [Feb 20, 2025](https://hashnode.com/posts/melhores-praticas-para-automatizacao-de-bancos-de-dados/67b75818822e0cb81ec1ab5b) ### [Melhores Práticas para Automatização de Bancos de Dados](https://dbatevolta.hashnode.dev/melhores-praticas-para-automatizacao-de-bancos-de-dados?utm_source=hashnode&utm_medium=feed) Automatize o Oracle Database com práticas modernas para aumentar a eficiência, reduzir erros e otimizar o desempenho 1 min read · [dbatevolta.hashnode.dev](https://dbatevolta.hashnode.dev/melhores-praticas-para-automatizacao-de-bancos-de-dados?utm_source=hashnode&utm_medium=feed) [Arindam Ghosh](https://hashnode.com/@arinpro) · [Jan 5, 2025](https://hashnode.com/posts/how-to-minimize-downtime-caused-by-table-locks-during-postgresql-schema-changes/677a3501bffcd860f246aea5) ### [How to Minimize Downtime Caused by Table Locks During PostgreSQL Schema Changes?](https://dbaguides.hashnode.dev/how-to-minimize-downtime-caused-by-table-locks-during-postgresql-schema-changes?utm_source=hashnode&utm_medium=feed) 🚨 Ever faced an unexpected downtime from a seemingly harmless database deployment?Imagine you're adding a new column to an existing table (e.g., users) in PostgreSQL. You decided to skip specifying a default value, thinking it would be a metadata-on... 2 min read · [dbaguides.hashnode.dev](https://dbaguides.hashnode.dev/how-to-minimize-downtime-caused-by-table-locks-during-postgresql-schema-changes?utm_source=hashnode&utm_medium=feed) [Vedant Sagolale](https://hashnode.com/@vedantsagolale12) · [Dec 12, 2024](https://hashnode.com/posts/database-joints-unveiled-from-basics-to-advanced-techniques/675b0822449fb11ec85af0b5) ### [Database Joints Unveiled: From Basics to Advanced Techniques](https://dbforpuredevelopers.hashnode.dev/database-joints-unveiled-from-basics-to-advanced-techniques?utm_source=hashnode&utm_medium=feed) Setting Up Our Example Database Let's create a practical scenario to illustrate database joints. We'll design a small business database with multiple interconnected tables. -- Create Departments Table CREATE TABLE Departments ( dept\_id INT PRIMAR... 7 min read · [dbforpuredevelopers.hashnode.dev](https://dbforpuredevelopers.hashnode.dev/database-joints-unveiled-from-basics-to-advanced-techniques?utm_source=hashnode&utm_medium=feed) [Nikhil Soman Sahu](https://hashnode.com/@nikhilsomansahu) · [May 12, 2024](https://hashnode.com/posts/25-common-questions-that-might-be-asked-in-a-database-administrator-dba-interview/66409c278956dec122e43394) ### [25 common questions that might be asked in a database administrator (DBA) interview](https://nikhilsomansahu.hashnode.dev/25-common-questions-that-might-be-asked-in-a-database-administrator-dba-interview?utm_source=hashnode&utm_medium=feed) Sure, here are 25 common questions that might be asked in a database administrator (DBA) interview: What is normalization and why is it important in database design? Explain the differences between a clustered and a non-clustered index. What is a ... 5 min read · [nikhilsomansahu.hashnode.dev](https://nikhilsomansahu.hashnode.dev/25-common-questions-that-might-be-asked-in-a-database-administrator-dba-interview?utm_source=hashnode&utm_medium=feed) [Arindam Ghosh](https://hashnode.com/@arinpro) · [Apr 30, 2023](https://hashnode.com/posts/setup-database-cicd-for-postgresql-using-flyway-and-github-actions/644e544e0bee08b410a8d660) ### [Setup Database CI/CD for PostgreSQL using Flyway and GitHub Actions](https://dbaguides.hashnode.dev/setup-database-cicd-for-postgresql-using-flyway-and-github-actions?utm_source=hashnode&utm_medium=feed) Continuous Integration/Continuous Deployment (CI/CD) ♾️ is a widely adopted practice in software development that helps ensure reliable and efficient delivery of applications. When it comes to databases, managing changes to a database can be complex ... 5 min read · [dbaguides.hashnode.dev](https://dbaguides.hashnode.dev/setup-database-cicd-for-postgresql-using-flyway-and-github-actions?utm_source=hashnode&utm_medium=feed) [Alex Skripov](https://hashnode.com/@skripov) · [Mar 23, 2023](https://hashnode.com/posts/mysql-documentation/641c631b06562252e16621c7) ### [MySQL documentation](https://skripov.hashnode.dev/mysql-documentation?utm_source=hashnode&utm_medium=feed) A few days ago I had a situation when I had to run some query on my MySQL server without access to the internet. And what I discovered. The default server build is compiled with MySQL docs on board :) Just in case, I needed JSON\_SCHEMA\_VALIDATION\_REP... 5 min read · [skripov.hashnode.dev](https://skripov.hashnode.dev/mysql-documentation?utm_source=hashnode&utm_medium=feed) [Olamigoke Oyeneyin](https://hashnode.com/@IamGo0ke) · [Mar 8, 2022](https://hashnode.com/posts/inside-the-oracle-instance-memory-structures-and-background-processes/6866c22ca770578d1e91ce50) ### [Inside the Oracle Instance: Memory Structures & Background Processes](https://iamgo0ke.hashnode.dev/inside-the-oracle-instance-memory-structures-and-background-processes?utm_source=hashnode&utm_medium=feed) Explore Oracle instance internals: memory structures like SGA and PGA, background processes like LGWR, DBWR, and checkpoints for database management 3 min read · [iamgo0ke.hashnode.dev](https://iamgo0ke.hashnode.dev/inside-the-oracle-instance-memory-structures-and-background-processes?utm_source=hashnode&utm_medium=feed) [Arindam Ghosh](https://hashnode.com/@arinpro) · [Jan 23, 2021](https://hashnode.com/posts/installing-pgbadger-on-linux-for-postgresql-log-analysis/640da2a101781c8ddf986107) ### [Installing pgbadger on Linux for PostgreSQL log analysis](https://dbaguides.hashnode.dev/installing-pgbadger-on-linux-for-postgresql-log-analysis?utm_source=hashnode&utm_medium=feed) As a DBA, we often encounter scenarios when we need to track PostgreSQL database performance by analyzing workloads and identifying bottlenecks if any. There comes pgbadger – an open-source log analyzer for PostgreSQL. It parses the PostgreSQL log fi... 18 min read · [dbaguides.hashnode.dev](https://dbaguides.hashnode.dev/installing-pgbadger-on-linux-for-postgresql-log-analysis?utm_source=hashnode&utm_medium=feed) [Arindam Ghosh](https://hashnode.com/@arinpro) · [Sep 14, 2020](https://hashnode.com/posts/how-to-recover-a-database-from-suspect-or-recovery-pending-state-in-sql-server/640d9c8299a0a43337b714a2) ### [How to Recover a Database from Suspect or Recovery Pending State in SQL Server?](https://dbaguides.hashnode.dev/how-to-recover-a-database-from-suspect-or-recovery-pending-state-in-sql-server?utm_source=hashnode&utm_medium=feed) So one or more of your databases went into RECOVERY PENDING state or in SUSPECT mode and you are confused about what to do now to fix the issue immediately. Do not panic 😨 Almost every DBA has encountered this scenario quite a few times in their pro... 4 min read · [dbaguides.hashnode.dev](https://dbaguides.hashnode.dev/how-to-recover-a-database-from-suspect-or-recovery-pending-state-in-sql-server?utm_source=hashnode&utm_medium=feed) [Arindam Ghosh](https://hashnode.com/@arinpro) · [Aug 9, 2020](https://hashnode.com/posts/how-to-create-an-amazon-rds-aurora-postgresql-database-cluster/640d9b595ba0075b2d10e7ff) ### [How to Create an Amazon RDS Aurora PostgreSQL Database Cluster?](https://dbaguides.hashnode.dev/how-to-create-an-amazon-rds-aurora-postgresql-database-cluster?utm_source=hashnode&utm_medium=feed) To keep up with the ever-changing and evolving tech industry, we want our databases to be easily scalable, replicable, fault-tolerant, and most importantly without having any administrative hassle. One of the best options to achieve this is to opt fo... 8 min read · [dbaguides.hashnode.dev](https://dbaguides.hashnode.dev/how-to-create-an-amazon-rds-aurora-postgresql-database-cluster?utm_source=hashnode&utm_medium=feed)