PHP: Solve undefined key / offset / property warnings. Multi-level nested keys
This is the ad hoc tutorial on how to solve php undefined key, undefined property warnings. Five different solutions are considered. Custom function is developed.
Run Multiple Databases (MySQL, Oracle, MSSQL, PostgreSQL, MongoDB) in Single Machine Using Docker (and Vagrant)
This is the ad hoc tutorial on how to setup and run multiple databases simultaneously (MySQL, Oracle, MSSQL, PostgreSQL and MongoDB) in single machine using Docker approach .
MySQL Selective/Exceptional Permissions and Backup/Restore
This is the ad hoc tutorial on how to provide exceptional or selective privileges to users, also how to backup/restore selectively in MySQL.
Setup Remote GIT Repository Server on CentOS 7
This is the ad hoc tutorial on how to setup remote GIT repository server on CentOS 7. We will create the local GIT server to serve as remote repository for team projects.
Export Powerpoint .ppt/.pptx 2000/2003/2007 Presentation to Video .mp4/.avi
This is the ad hoc tutorial on how to export the Microsoft Powerpoint 2000/2003/2007 presentations .ppt/.pptx to video format .mp4/.avi including animations.
How to Export Excel Sheet to CSV with Unicode/UTF-8
This is the ad hoc tutorial on how to export the excel sheet to CSV format with unicode characters. We will provide two options using Excel+Notepad and LibreOffice.
Find Stationary Distribution of Markov Chain using Stochastic Simulation (Gillespie’s) in Python
This is the ad hoc tutorial on how to simulate continuous Markov Chain using Gillespie’s Direct Stochastic Simulation algorithm and find its stationary distribution and estimate the accuracy.
Fix Oracle “IO ERROR: The network adapter could not establish the connection” error
This is the ad hoc tutorial on how to fix “IO ERROR: The network adapter could not establish the connection” error while trying to connect Oracle Database.
Create SFTP User / Group with CHROOT option in Linux / Unix
This is the ad hoc tutorial on how to create sftp user with chroot option in CentOS. We will create a single sftp user with chroot folder and separate sftp group with the users having dynamic chrooted home folder.
Setup ORACLE 12C / 11G PDO for PHP 7.2 / 7.x
This is the ad hoc tutorial on how to enable PHP PDO for ORACLE 12C / 11G. We’ll install the Oracle pdo package, create the php configuration file and test the connectivity with PDO to ORACLE server.