Using VLookup like Batch script to compare two excel / csv
Kedar
Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2…
bat – batch file to create formatted date time (ddmmyyyy) directory
In batch scripting, generating file and directory names with current date and time stamps can greatly enhance organization and workflow. This tutorial will walk you through various code snippets and…
Calculate MySQL Memory Usage – Quick Stored Procedure
In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…
Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4,…
Monitor multiple mysql replication using php: Updated
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…
Movie review: Ajab Prem Ki Gajab Kahani
Yes !! It is a Gajab Kahani, the name is perfectly chosen by the director Rajkumar Santoshi but it would have been better if he had taken a better script and…