top of page
Search
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...
Balaaji Dhananjayan
Oct 10, 20252 min read
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...
Balaaji Dhananjayan
Oct 9, 20251 min read
AlloyDB Studio
A preview of AlloyDB Studio
Balaaji Dhananjayan
Mar 21, 20241 min read
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..
Balaaji Dhananjayan
Mar 20, 20241 min read
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...
Balaaji Dhananjayan
Dec 5, 20223 min read
Creating and connecting to Amazon DocumentDB Cluster
This post talks about how to create and connect to the Amazon DocumentDB cluster.
Balaaji Dhananjayan
Nov 30, 20223 min read
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...
Balaaji Dhananjayan
Nov 30, 20222 min read
Balaaji Dhananjayan
Dec 20, 20210 min read
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...
Balaaji Dhananjayan
Dec 20, 20212 min read
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...
Balaaji Dhananjayan
Dec 19, 20212 min read
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...
Balaaji Dhananjayan
Dec 19, 20214 min read
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...
Balaaji Dhananjayan
Aug 2, 20211 min read
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...
Balaaji Dhananjayan
Jul 18, 20212 min read
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...
Balaaji Dhananjayan
Jul 17, 20212 min read
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...
Balaaji Dhananjayan
Jul 15, 20212 min read
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(),...
Balaaji Dhananjayan
Jul 14, 20212 min read
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...
Balaaji Dhananjayan
Aug 30, 20202 min read
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...
Balaaji Dhananjayan
Jun 3, 20202 min read
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...
Balaaji Dhananjayan
May 18, 20202 min read
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...
Balaaji Dhananjayan
May 11, 20201 min read
bottom of page