MS SQL Database CSV Export – Part 2

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 »

MS SQL Database CSV Export – Part 1

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 »

Silently Remove all Java

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 »

Deploying Adobe AIR Apps

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 »

Boot into Windows on Ubuntu Dual-Boot via Command Line

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 »

Remove directories that start with a number

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 »

Happy Labor Day Weekend!

Happy Labor Day Weekend! (For those in the US) Finally got some time to move my sites to a new host and revamp a few things. In the process this blog was born, not that we needed yet another tech blog, but check out the About page and come back soon to see what I’m talking about.