Monthly Archives: January 2024

MONGODB INSTALLATION IN WINDOWS

INTRODUCTION MongoDB is an open source NoSQL database management program. NoSQL (Not only SQL) is used as an alternative to traditional relational databases. NoSQL databases are quite useful for working with…

Read More

How to Install Apache Kafka in Windows

1. Overview This document talks about how to install Apache Kafka for windows. [Note: Steps included in this document will only works windows server] 2. Technologies and Tools Used The…

Read More

How to Install Apache Nifi in Windows

 1. Overview This document talks about how to install Apache Nifi for windows. [Note: Steps included in this document will only works windows server] 2. Technologies and Tools Used The…

Read More

Interatcive Organizational Charts in Oracle APEX

Overview: This blog talks about organization charts in Oracle Apex using third-party libraries or plugins since Oracle APEX does not have a built-in organization chart component. Technologies and Tools Used:…

Read More

Virtual Private Database (VPD) in Oracle APEX for securing data access

Overview: This blog talks about VPD (Virtual Private Database) in Oracle Apex, a feature that helps address security concerns by restricting access to data at the row level based on…

Read More

SQL query optimization best practices

SQL Server performance tuning and SQL query optimization are some of the main aspects for database developers and administrators. They need to carefully consider the usage of specific operators, the…

Read More

Identifying SQL Server Performance Issues

Detecting and resolving performance problems in SQL Server is crucial for database developers and administrators. Utilizing dynamic management views (DMVs) can provide insights into a server instance’s current state and…

Read More

Installing MySQL on linux

Installing  MySQL on linux STEP -1 -Download the rpm required based on your operating system here iam using linux -User the below link to assess the RPM -Link- https://dev.mysql.com/doc/refman/8.1/en/ Downloading…

Read More

Retrieving current row values of Interactive Grid in Apex using JavaScript

Accessing a value in the client side is important in any development. It will help the developer to do validations, setting value and other required changes in the UI before…

Read More

How to create custom shortcuts for Interactive Repot fields in Oracle APEX

  Overview This document explains about how to create custom shortcuts for Interactive report fields in Oracle Apex. Technologies and Tools Used The following technology has been used to create…

Read More