Nikhil Soman Sahunikhilsomansahu.hashnode.dev·May 12, 202425 common questions that might be asked in a database administrator (DBA) interviewSure, 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 ...DiscussSQL
Arindam Ghoshdbaguides.com·Apr 30, 2023Setup Database CI/CD for PostgreSQL using Flyway and GitHub ActionsContinuous 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 ...Discuss·2.1K readsCI/CD
Alex Skripovskripov.hashnode.dev·Mar 23, 2023MySQL documentationA 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...Discuss·73 readsMySQL
Arindam Ghoshdbaguides.com·Jan 23, 2021Installing pgbadger on Linux for PostgreSQL log analysisAs 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...Discuss·5.0K readsPostgreSQL
Arindam Ghoshdbaguides.com·Sep 14, 2020How to Recover a Database from Suspect or Recovery Pending State in SQL Server?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...Discuss·199 readsSQL Server
Arindam Ghoshdbaguides.com·Aug 9, 2020How to Create an Amazon RDS Aurora PostgreSQL Database Cluster?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...Discuss·115 readsPostgreSQL
Arindam Ghoshdbaguides.com·Aug 2, 2020Restoring a Sample Database into PostgreSQLIn the process of learning a new database technology, testing out various features and following a tutorial, what you require is a sample database. Like other DBMS, there are several sample databases available for PostgreSQL as well. PostgreSQL has s...Discuss·213 readsPostgreSQL
Arindam Ghoshdbaguides.com·Jul 18, 2020Configuring PostgreSQL for the First TimeWe have discussed the PostgreSQL installation steps here. Next comes the initial configuration part. We will separate the initial configuration into two steps: Enable Remote Connections Set Server-Level Options Before we proceed further, let’s br...Discuss·291 readsconfiguration
Arindam Ghoshdbaguides.com·Jun 22, 2020Installing PostgreSQL on Linux [CentOS] – A Step by Step GuidePostgreSQL has earned a strong reputation for being the world’s most advanced open-source Relational database. Over the past few years, it has seen a sharp rise in popularity as a Tier-1 RDBMS and more and more organizations are embracing PostgreSQL ...Discuss·292 readsPostgreSQL
Arindam Ghoshdbaguides.com·Jan 6, 2020How to troubleshoot high CPU utilization issue in SQL Server?So you have received a high CPU utilization alert from your monitoring system and wondering what to do next. If yes, then this blog post might be helpful for you.You can follow the below steps to isolate the problem and mitigate it. Open the task ...Discuss·703 readscpu
![Installing PostgreSQL on Linux [CentOS] – A Step by Step Guide](https://cdn.hashnode.com/res/hashnode/image/upload/v1678611544270/a9519a34-10b4-40ed-8194-b819948b8fc0.png?w=1600&h=840&fit=crop&crop=entropy&auto=compress,format&format=webp)
