Payal Sinha

Connection cqlsh # local connect cqlsh <host> <port> # remote cqlsh -u <user> -p <pass> # with auth Keyspace Ops -- create CREATE KEYSPACE ks_name WITH replication = {'class':'SimpleStrategy', 'replication_factor':3}; -- use USE ks_name; --

I’ve always believed that the best way to truly learn something new is to throw yourself into it — confusion, curiosity, and all. That’s exactly how my journey into the world of Azure began. Coming from a background where cloud services weren’t a part of my day-to-day work,

After eight years of working with Oracle databases, I thought I understood distributed systems pretty well. Oracle RAC, Data Guard, partitioning - I'd done it all. Then I encountered Apache Cassandra, and realized I needed to unlearn almost everything I knew about databases. The First Shock: No Master

Standard Operating Procedures for technical operations often fall into two traps: either they're so vague they're useless ("restart the service if it fails"), or so rigid they become obsolete the moment your infrastructure changes. The best technical SOPs strike a balance—specific enough to

Imagine you run a popular clothing store in a busy shopping district. Every day, customers come in, buy items, and you carefully record each transaction in your ledger. Business is booming, but you have a nagging worry: What if something happens to my store? A fire, a flood, a power

Last Tuesday, I spent forty minutes trying to remember how I'd solved that gnarly Redis caching issue. You know, the one that had me pulling my hair out for three days straight back in March? The elegant solution I was so proud of? The one I swore I&

Every database administrator has faced that moment of dread—realizing that critical data might be lost, corrupted, or compromised. Whether it's hardware failure, human error, or a ransomware attack, the question isn't if you'll need your backups, but when. Understanding the different backup strategies

In today's always-on digital economy, database downtime is no longer acceptable. Whether you're migrating to the cloud, upgrading infrastructure, or consolidating data centers, businesses demand zero interruption to their operations. This is where Oracle GoldenGate shines as a battle-tested solution for real-time data replication and zero-downtime