Here is an OLD article I had about data caching in classic asp using the application object. When it comes to application performance on your web servers, ever little bit counts. Howto build a database caching system Introduction In this tutorial I will teach you how to build a simple database caching system to improve […]

Here is how to Export Windows Scheduled Task Information to File with Command Line: schtasks /query /fo CSV /v >> scheduled_task_metadata.csv This will dump a list of scheduled tasks and their advanced settings to a CSV file called “scheduled_task_metadata.cs” to whichever location you run the command prompt from. If you don’t want the windows scheduled […]

What is a Disconnected Recordset? A Disconnected Recordset is A recordset object that exists in an application, but does not have an associated data connection associated with it. Why use a Disconnected Recordset? The ADO Recordset is considered an extremely “rich object model” which means it provides more functionality than say, an array. Also, you can load […]

This is a simple VBS VBScript that I use to delete all files in a given folder on a machine. It is particularly useful to delete internet cache files or cookies. You can set a scheduled job actually, to perform this task nightly. This script could be easily modified to, say, clear out your temporary […]

I needed a quick vbscript to terminate a specific windows process that seemed to hang. This is the script that will do it. It uses SQL to lookup the process name from the win32_process list, then uses the terminate function to close it. NOTE: this vbs to terminate a windows process was only tested on […]

Here is a snippet of vbscript I use in ASP and/or VBS applications where I need a select case statement for a range of values for each case. There isn’t too much documentation online about this, and it’s a bit of a hack, but this will do the trick. 1 2 3 4 5 6 […]