Comparing OLE DB and ODBC This document compares the basic features of OLE DB to the basic features of ODBC (Open Database Connectivity). It is intended to help clarify when to use one over the other. Introduction OLE DB vs ODBC OLE DB and ODBC are both specifications created by Microsoft to address universal data access. […]

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 […]

MYSQL Statements and clauses ALTER DATABASE ALTER TABLE ALTER VIEW ANALYZE TABLE BACKUP TABLE CACHE INDEX CHANGE MASTER TO CHECK TABLE CHECKSUM TABLE COMMIT CREATE DATABASE CREATE INDEX CREATE TABLE CREATE VIEW DELETE DESCRIBE DO DROP DATABASE DROP INDEX DROP TABLE DROP USER DROP VIEW EXPLAIN FLUSH GRANT HANDLER INSERT JOIN KILL LOAD DATA FROM […]

These are some MySql commands (most run at the command line in linux) that I’ve been collecting since getting a few sites set up on linode. The “#” indicates that it is to be run from the unix shell. When you see “mysql>” the command is to be run from the MySQL command prompt after […]

If you are looking for a Cross Browser Compatible CSS Opacity code, you need look no further. The following provides 100% opacity (which is the same as 0% transparency.) 1 2 3 4 5 6 7 8 9 10 Body {   …your body css…   -moz-opacity: 1.0 !important; -webkit-opacity: 1.0!important; -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=100)" !important; filter: alpha(opacity=100) !important; opacity: […]

Groove is a component of Microsoft Office enterprize 2007. If you don’t use the groove service, you can uninstall it. Go to “Add-Remove Programs” find your MS office installation in the menu click CHANGE (not remove) Find the Groove item in the list Change the indicator to “Not available” let the process finish reboot. This […]

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 simple credit card expiration date regular expression. I wrote my own regexp for the expiration date since one was not easily found on the net. This one validates for allowing the year 2009 to 2029, but could be easily changed…I built this for an ASP.NET programming project for a course I’m taking. […]

I needed to edit a recording I made from a TV show with the Windows Media Center, and I assumed at first that the files would be .avi or .wmv or something I was used to. It turns out that they were .DVR-MS format, which is a proprietary MS format that can not be easily […]