After doing some work with Azure VMs and scale sets I’ve found out that, generally, selecting the same size SKU does not mean getting the same performance. On top of that, some of the newer generation sizes (v2 vs v3) are not available in certain region+zone combinations affecting availability configuration options for desired sizing SKUs. Performance. For example… Read More »
The following script allows you to update your /etc/hosts file in a regular interval. By configuring a hostname and list of IPs, you can distribute requests to several hosts over time automatically. All you have to do is configure this script, add it to your crontab file, and point your application or script to the configured hostname. In… Read More »
In a previous post, we described a method to query a MS SQL database and export the results to a CSV file using a batch script. This post will expand on the previous solution to include a way to upload the CSV file to a PHP web server using cURL. Also, the PHP page can generate an email… Read More »
The following process describes how to connect to a MSSQL database, run a query, and save the result as a CSV file; all via command line so it can be easily added to a batch file and scheduled to run via Task Scheduler or any other mechanism. In “part 2”, I will describe how to create a simple… Read More »
In Microsoft Windows I frequently run into situations where customers have several outdated versions of Java, or not the “right” version required for a particular vendor. Removing Java via Programs and Features is not the fastest and I sometimes found there are versions of Java that remain in the system even if they are not listed under Programs… Read More »
Happy belated Thanksgiving! Recently had to do some work deploying an Adobe AIR application and came up with a nifty batch file that takes care of silently doing this for me. It has a few extras in there like disabling Adobe AIR update prompts and re-installing/updating the app if it already exists. A few things to note before… Read More »
The following solution shows how you can query two tables in a DB2 database for user IDs that have a password older than 90 days and are in the “LOCKED” group. We will need to join the tables but a simple JOIN won’t do as we get may rows for the same user. This is due to group membership… Read More »
If you have the local “administrator” account for a Windows PC, you can run the batch script below to list the running tasks. This script will actually run for the local PC (localhost) or it can connect to another machine over the network as long as you know that machine’s local admin password. To use, you can just… Read More »
Frequently found myself needing a way to remotely boot into Windows from a Ubuntu dual-boot machine. Looking at grub.cfg, I found there was only one “windows” option, so the following command allowed me to remotely boot into that partition via command line: sudo grub-reboot “$(grep -i ‘windows’ /boot/grub/grub.cfg|cut -d”‘” -f2)” && sudo reboot You can create a shell… Read More »
The linux shell script below comes in quite handy when you need to delete all folders that start with a number in a path that contains other folders you don’t want to remove. The script contains some logic to only run as root and stop/start a service if needed. Also, I’ve included a sample crontab line to run… Read More »