Feb 20, 2025 · 1 min read · Introdução Definição de Automatização em Banco de Dados Importância da Automatização para o Oracle Database Objetivo do Artigo Fundamentos do Oracle Database Visão Geral do Oracle Database Componentes Principais Funcionalidades Essenciais Benefícios ...
Join discussionJan 5, 2025 · 2 min read · 🚨 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...
Join discussion
Dec 12, 2024 · 7 min read · 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...
Join discussionMay 12, 2024 · 5 min read · 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 ...
Join discussionApr 30, 2023 · 5 min read · 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 ...
Join discussion
Mar 23, 2023 · 5 min read · 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...
Join discussionMar 8, 2022 · 3 min read · if you missed the previous post on Oracle Database Architecture, check it out here to get the full context before diving into this one. Please subscribe and follow for more. In this post, we’ll explore what happens inside the instance — from memory s...
Join discussion
Jan 23, 2021 · 18 min read · 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...
Join discussion
Sep 14, 2020 · 4 min read · 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...
Join discussion
Aug 9, 2020 · 8 min read · 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...
Join discussion