Does Google Spanner defy CAP theorem
First — What CAP Really Means CAP theorem (Consistency, Availability, Partition tolerance) states that in the presence of a network...
10 Oct 2025Read article
IDEAS, EXPLAINED. KNOWLEDGE, SHARED.
The notebook.
Database deep dives, cloud discoveries, and practical lessons from the field.
27 articlesNewest first
Best Practice for Schema Design in Oracle Database — My Perspective
In my experience, one of the most effective and maintainable schema designs in Oracle is to separate ownership and usage through a...
9 Oct 2025Read article
Install Oracle GoldenGate 19c on Linux
Prepare a Linux host, install GoldenGate 19.1.0.0.4 with Oracle Universal Installer, and verify GGSCI and Manager with a clear, illustrated walkthrough.
5 Oct 2025Read guide
Intelligence behind Google's AlloyDB
This post talks about how google has designed AlloyDB internally by using its best services internally like Borg, Colossus, etc..
20 Mar 2024Read article
Role Based Access Control (RBAC) on Amazon DocumentDB
Welcome to my another post about RBAC (Role Based Access Control) on Amazon DocumentDB. Access restrictions are always important to keep...
5 Dec 2022Read article
Creating and connecting to Amazon DocumentDB Cluster
This post talks about how to create and connect to the Amazon DocumentDB cluster.
30 Nov 2022Read article
Creating a New User account in Amazon DocumentDB
In this post, let's see how we can create and administer a new user in Amazon DocumentDB service. Amazon DocumentDB (with MongoDB...
30 Nov 2022Read article
In teaching others, we teach ourselves | dbgenre
In teaching others, we teach ourselves | dbgenre
20 Dec 2021Read article
CloudSQL backup and restore
As our life gets more and more easy to handle our infrastructure on Cloud. I came across backing up and restoring databases from a...
20 Dec 2021Read article
Setting up Password-less authentication to Oracle Database
As the world moves into end-to-end automation, it is also important for us to secure the passwords into a vault or wallet so they are...
19 Dec 2021Read article
Securing Oracle Database connection with SSL/TLS
In this article we’ll see how to secure the connection between a client/application and an Oracle DB using SSL/TLS certs. Automation is...
19 Dec 2021Read article
Oracle Database 19c Standalone installation
I have written this article keeping in mind a college student to be able to install Oracle 19c Database software to start exploring. So...
2 Aug 2021Read article
Oracle database features and enhancements
Surf through this page to know about features and enhancements that were released on each version from 12cR1. I'll try to cover these...
18 July 2021Read article
Convert Non Partitioned table into Partitioned
It happens to be DBAs sometime end up converting non partitioned table into partitioned table based on new use cases or requirements...
16 July 2021Read article
Create Users Like Another User In Oracle Database
It is always a challenge for a DBA to get a quick pick on methodology to clone/mirror an User ID with same privileges as other user. It...
15 July 2021Read article
Difference between update(), updateOne() and updateMany() in MongoDB
As I read through some of the blog posts, there are many people out there, who ask for what is the difference between what is update(),...
14 July 2021Read article
Creating ReadOnly service in Oracle ADG (Active DataGuard)
Every setup generally has a problem of developers connecting to active (or Primary) instance to run a few selects to know the status of...
30 Aug 2020Read article
How to find and remove table level lock in Oracle
Dear Blog readers, Today let's see how to find and remove the table level lock in Oracle and in what case we would require to do so. An...
3 June 2020Read article
Registering a Database in Server Control (srvctl)
There are times if the database is not build using DBCA or not upgraded using DBUA, the database resource may not be registered with your...
18 May 2020Read article
Unusable Indexes
Oracle indexes can go into UNUSABLE state after a maintenance operation on the table or if the index is marked as 'unusable' with an...
10 May 2020Read article
ASM to ASM file copy using DBMS_FILE_TRANSFER
There will be occasions where we may have to refresh databases and not all time we will have space in our regular OS disks.. What can we do? Well, lets try to make use of FRA space where you
4 May 2020Read article
Manage a fast refreshable materialized view
Understand materialized views, configure fast refresh, and work with materialized view logs in Oracle.
Installation guideRead guide
Oracle Database 19c on VMWare Workstation PRO
A complete walkthrough for installing Oracle Database 19c on Oracle Linux 7 with VMware Workstation Pro.
Installation guideRead guide
Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 7 Using VirtualBox
Build a two-node Oracle 12c RAC environment on Oracle Linux 7 using VirtualBox, from networking to Grid Infrastructure.
Installation guideRead guide
Oracle Linux 7 (update 8) installation guide
Install Oracle Linux 7.8 in a virtual machine and configure the network, packages, and operating system.
Installation guideRead guide
Version wise features and enhancements
A version-by-version reference to Oracle Database features and enhancements from Oracle 12c onward.
Installation guideRead guide
No articles found.
Try another word or explore a different topic.