Calculate Number of Days between Two Dates in Informix
This is how I calculate the number of days between two dates. Suppose I have a small table: Customer Name LastLogon select current year to day - extend(customer.lastlogon,…
Author
Rich
Just another IT guy.
Misys Vision Encounter Templates
Misys Vision Encounter (Superbill) Templates SQL Query: select tmpname,tmpdesc from formtmphdr where allow_edit = 'N' and tmptype = 7 tmpname tmpdesc CODESCAN1S MICROSCAN ENCOUNTER 1 (8 LPI -…
vzlist Output Parameters and Their Specifiers
OpenVZ 'vzlist' command information vzlist Output Parameters and Their Specifiers Almost any parameter that can be used after the -o and -s switches of the vzlist utility can…
Common OpenVZ Tasks
Common OpenVZ Admin Tasks vzctl act as a master tool for various tasks: How Do I Set VPS Name to vps.foo.bar? # vzctl set 10 --hostname vps.foo.bar --save…
Basic IPtables Firewall
This is a very simple iptables firewall scripts to get you started. I use this all the time as a basis. It allows for access to your system…
Find Current Location of Data and Log Files for SQL Server
A quick method to find all the data and log file paths for all databases on a database server instance. SELECT name, physical_name AS current_file_location FROM sys.master_files Example…
Cheap VPS Hosting
No Longer Available. I am starting to host public VPS for anyone interested. They are OpenVZ containers and I have a few plans available. 1. "Lite" $8/mo.64MB RAM…
CentOS Install Types and Descriptions
CentOS 6 Install Option Descriptions for Desktop, Minimal Desktop, Minimal, Basic Server, Database Server, Web Server, Virtual Host and Software Development Workstation
OpenVZ Templates
Here’s a few links to the OpenVZ templates which include stable, beta, old and user contributed templates: http://wiki.openvz.org/Download/template/precreated http://download.proxmox.com/appliances/
CentOS Netinstall URL
These are the valid 32 and 64bit CentOS6 netinstall URLs. 32bit: http://mirror.centos.org/centos/6/os/i386 64bit: http://mirror.centos.org/centos/6/os/x86_64 Of course, you could have this mirrored locally – just replace with your local…
Free Web Based Asset Management
I came across a gem this morning while starting the dubious task of reviewing what's out there in regards to asset management software. This project blows me away.…
Ping Sweep from Windows Command Line
I remote connect into networks frequently and there are times when I'm not sure what is on the network (like network printers, etc.) and I need to find…
Changes in Outlook 2010
http://technet.microsoft.com/en-us/library/cc179110.aspx
Calculate How Many Pavers are Needed for Patio
Here's an easy way to determine how many pavers are needed for the new patio you are building. Let's assume the following... Patio Area: 16'Wx12'L Paver: 8Wx12H Square…
Google Adsense Revenue
Seeing I almost earned last month in one day with Google Adsense is pretty awesome!