Author

Rich

Just another IT guy.

Informix – Get last executed SQL query

February 8, 2012

This is my preferred method. onstat -g ses <sesid> Where <sesid> is the session id of the connected user querying the database. To get the session id onstat…

Windows 7 – Problem Steps Recorder

February 6, 2012

Neat feature, didn't even know about it. Windows 7 has a tool to help techs troubleshoot user problems by allowing the end-user to record in screenshots the steps…

Get ALL table and column descriptions in MSSQL

February 2, 2012

Get MS_Description from all tables AND columns in a database. Suh-weet. SELECT u.name + '.' + t.name AS , td.value AS [table_desc], c.name AS [column], cd.value AS [column_desc]…

wmic output hangs when using psexec

February 2, 2012

I recently found when trying to issue a wmic query on a remote system with psexec (1.98) it would hang and not display results. The solution is to…

Check for configuration errors with FAM/Gamin Library

February 1, 2012

Popup in Outlook and webmail: Your IMAP server wants to alert you to the following: filesystem notification initialization error -- contact your mail administrator (check for configuration errors…

FastClaims for Tiger in AIX

January 31, 2012

So I've discovered that FastClaims in Allscripts Tiger AIX servers are stored in the following location. When a receipts are batched, they are stored in /m2/MF01/CLAIM499 When clicking…

Traffic Shaping and Policing in Cisco IOS

January 30, 2012

I needed to setup bandwidth shaping on a router recently for testing purposes and decided on the below configuration on my Cisco router.  I know this drops packets…

MSDN Bug Check Code Reference

January 30, 2012

Bug Check Code Reference from MSDN http://msdn.microsoft.com/en-us/library/windows/hardware/hh406232(v=vs.85).aspx Great site with lots of collected information from an MVP http://www.carrona.org/bsodindx.html I once had a complete listing with search capability (https://techish.net/bugcodes/)…

SQL Performance Monitoring

January 26, 2012

I have read numerous articles all over the 'net regarding performance counters to monitor, etc. This is a snapshot of a typical performance monitoring session I use to…

SQLIO Scripts and Graphs

January 24, 2012

One of probably hundreds of SQL scripts out there. This is what I made and use... and I like it. There are a lot of other scripts out…

SQL Show Jobs that Will Run

January 18, 2012

This will show jobs that will run. I lost the link I found this at. Eventually, I need to add a few columns to report scheduling information, etc.…

Check Fragmentation on Objects in SQL Database

January 18, 2012

tsql so I can remember in the future. declare @db_id int declare @object_id int set @db_id = DB_ID('EMR') set @object_id = 0 select  db_name(@db_id) as [database], object_id, object_name(object_id,…