PostgreSQL Installation & Setup on macOS Introduction to PostgreSQL What is PostgreSQL? PostgreSQL is a powerful, open-source relational database management system (RDBMS). It is widely used by startups, enterprises, and developers because it is reliable, scalable, and similarly follows SQL standards. PostgreSQL supports: ● Structured… Read More
Introduction to SQL What is SQL? SQL (Structured Query Language) is a database computer language used to communicate with and retrieve data from relational databases. It allows users to store, manipulate, update, and retrieve data efficiently. SQL is widely used with popular database systems such… Read More
Linux / UNIX PATH, ls Command and File Access Permissions (Security) Introduction Linux and UNIX are powerful open-source operating systems widely used in servers, cloud platforms, development environments, and academic institutions. To work efficiently in Linux/UNIX, it is very important to understand PATH concepts, the… Read More
Linux / UNIX File and Directory Management Commands Introduction Linux and UNIX are powerful, open-source operating systems widely used in servers, cloud platforms, development environments, and academic institutions. File and directory management is a fundamental skill for working efficiently in UNIX/Linux systems. These operating systems… Read More
SQL SERVER INSTALLATION INTERNALS Installing Microsoft SQL Server is often treated as a routine DBA task : launch the installer, click Next a few times and wait for the green checkmark. But under the hood, SQL Server setup performs a carefully controlled sequence of validations,… Read More
Basics of UNIX Operating System UNIX is an operating system, similar to Windows. An operating system is a collection of multiple software programs that manages all the resources of a computer such as the CPU, memory, and storage. UNIX can be understood in the following… Read More
Understanding SQL Server Architecture Microsoft SQL Server is a relational database management system (RDBMS) designed to store, manage and retrieve data efficiently. To achieve high performance, reliability and scalability SQL Server is structured into several inter-related components that work together to process user queries, manage… Read More
MySQL Installation 2- Types of installation packages 1- MySQL Installation using generic binaries In this we can select the version (older version of MySQL) 2- MySQL Installation using YUM on RHEL Which is available with Repositories, supported latest version (APT=GET) Through Putty we connect by… Read More
Automating OSWatcher Log Capture with oswlogs_capture.sh Monitoring system performance is essential for ensuring stability, especially in production environments. Oracle’s OSWatcher (OSWbb) is a powerful tool that continuously captures vital operating system metrics. However, extracting logs for specific time periods can be cumbersome without a bit… Read More
COMPRESSION IN CASSANDRA Operators can set up compression on a per-table basis with Cassandra. By compressing the SSTable in user-configurable compression chunk_length_in_kb, compression minimizes the amount of data on disk. The CPU cost of compressing data is only required when the SSTable is written since… Read More
