In our more and more connected world, security is a big concern. Storing password is a very important topic because if a machine is compromised,…
View More Use a wallet to encrypt Oracle client passwords
How to Generate a Running(Accumulated) Total in SQL
Have you ever needed to calculate a “running total” or “cumulative sum” in SQL? You can do this in SQL without any other programming language…
View More How to Generate a Running(Accumulated) Total in SQL
Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having…
View More Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime
Oracle RAC interview Questions
What is RAC?RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance…
View More Oracle RAC interview Questions
What is the difference between RPO and RTO ?
Predicting a future disaster is nearly impossible, but fortunately, preparing for one and deciding your organization’s aftermath is getting easier. Their abbreviated names are very…
View More What is the difference between RPO and RTO ?
Oracle Database Architecture
Oracle Database employs a client-server architecture, with the database server and client connections running in separate processes. The server process manages data and resources, and…
View More Oracle Database Architecture
Run multiple instances of MySQL Server on Windows 10
You can download it from here. Now, run the MySQL community installer. In MySQL Installed, you can view the list of installed products. To add…
View More Run multiple instances of MySQL Server on Windows 10
MySQL InnoDB Cluster 8.0 setup
MySQL InnoDB Cluster has proven with the first GA release its potential as the native out-of-the-box HA solution for MySQL. With the second GA release,…
View More MySQL InnoDB Cluster 8.0 setup
How to add a cron job on Windows Scheduled tasks and cron jobs on Windows
On Microsoft Windows, cron jobs are known as Scheduled Tasks. They can be added through the Windows Task Scheduler user interface, by using PowerShell or…
View More How to add a cron job on Windows Scheduled tasks and cron jobs on Windows
MySQL Master/Slave Replication in Windows
This guide will walk you through creating MySQL replication on existing live MySQL servers on Windows. While some downtime is required, we try to keep…
View More MySQL Master/Slave Replication in Windows