Dba

Understanding Your Emotional Responses in the Workplace — This article is about understanding your emotional responses in the workplace and how to manage them effectively. It is for professionals who want to improve their emotional well-being and find ways to stay focused, productive, and engaged at work. …

In this article we will see some handy SQL queries that can be used by any system administrators to achieve basic tasks in the organization database. …

Hey, Mariadb fans! It’s time to talk about the elephant in the room.

What is the easiest dance move you know? I believe you must have seen very good dancers as well as pathetic and terrible ones. Everyone tends to believe they are good dancers; even people who seem to find it so hard to follow the beat of a musical sound. There…

Can we store documents in Postgres? Is PostgreSQL can be used as a NoSQL Document database? Can we store semi-structured data in (Aurora) Postgres database clusters? The answer is YES. PostgreSQL offers two datatypes for storing JSON documents data: json and jsonb. For more than a decade, JSON/JSONB have been…

Are you a business enthusiast who desires to advance your knowledge and expertise in the field of business administration? Well, pursuing higher education can be your game-changer. However, you may be stuck in DBA vs PhD in Business Administration dilemma. Choosing between DBA and PhD in Business Administration is a…

You know… the life as a freelancer isn’t easy, however, sometimes you must to got paid for your experiences. Or It was an odds opportunity? As a freelance DBA, I have always been passionate about exploring different database management systems and learning new techniques to optimize their performance. …

bloatting, Long-running transactions, Lock contention, Increased disk I/O. Your database are in fire? Take care and don’t type VACCUM commands before read this article. PostgreSQL is a powerful open-source database management system that is widely used in the industry. One of the key features of PostgreSQL is its ability to…

In Part 1 we saw how to configure the Oracle Cloud Infrastructure (OIC) service called Database Management. Two options are available, Basic and Full Management, here the differences: Basic Management is a free option that provides several database metrics. The Enterprise Edition database additionally includes access to the “Performance Hub”…