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
INSTALLING CASSANDRA USING DEBIAN PACKAGES Debain Package: It is a collection of files which are used to implement a set of features or commands. You can only use the Debain packages on Ubuntu and other Debain-based distributions. STEP-1: Java setup Check the version of Java… Read More
OBJECT ORIENTED PROGRAMMING IN PYTHON Object-Oriented Programming (OOP) is a powerful paradigm that allows developers to structure their code in a more organized and modular way. In Python, OOP is implemented through classes and objects, which encapsulate data and behavior into reusable components. Python is… Read More
CASSANDRA INSTALLATION USING TARBALL BINARY FILE ▪️ We have 3 methods of installing Cassandra. In that this one is the one of the methods. ▪️ This will be installing in the Linux terminal only. ▪️ Follow the steps accordingly to install Apache Cassandra in Linux… Read More
SIZE TIERED COMPACTION STRATEGY: The traditional suggested compaction technique is the Size Tiered Compaction Strategy (STCS), which is advised for workloads that involve a lot of writing. If no other compaction strategy is specified, this one is used by default. When Cassandra has amassed a… Read More
HOW TO CHOOSE SS TABLES TO COMPACT SSTables are separated by density leveling in levels determined by the fan factors of the compaction setup. The amount of SSTables on a level, however, cannot be used as a trigger because there may be non-overlapping SSTables, unlike… Read More
FUNCTIONS IN PYTHON FUNCTION: ▪️ A function is a block of code that performs a specific task. ▪️ Functions are defined by using the def keyword which follows by function name and parentheses which may have parameters. ▪️ Any function can accept zero or more… Read More
