Free web based virus checker - Eset.com

Wanted to use an 2nd virus checker, to test a suspicious file, most free virus checkers require download/installation these days, Eset does not. 
Plus, it got good a recommendation from 7tutorials.com



http://www.eset.com/us/online-scanner/

Google Invisibilty issue - Always Online problem with Google Chat

In google chat, I was always visible, you have to manually delete a stuck process.  Here are step by step directions:


http://karthikkn.wordpress.com/2013/07/16/fixed-the-always-online-problem-with-google-chat/

SQL Query for Invoices in Sierra

Below is a query that retrieves the invoice number and grand total for invoices paid during a specific date range to a specific vendor. Somebody at another library constructed it, which successfully retrieves this information for all vendors during a specific period:

SELECT
ir.invoice_number_text AS "Invoice Number",
ir.grand_total_amt AS "Total",
irs.vendor_code
FROM
sierra_view.invoice_record ir
JOIN
sierra_view.invoice_record_vendor_summary irs
ON irs.invoice_record_id = ir.id
WHERE
ir.paid_date_gmt BETWEEN '01/22/2014' AND '01/23/2014'

When you run this query, the correct vendor codes display in the data output, but when they added the following vendor condition to the WHERE clause, get no results.

WHERE
ir.paid_date_gmt BETWEEN '01/22/2014' AND '01/23/2014'
AND irs.vendor_code = ‘oing’

Turns out you need to say  irs.vendor_code = ‘oing ’
vendor code followed by space.  The vendor code field is defined as 5 characters, ansd any codes less than 5 characters get padded with trailing spaces

Testing browser for Silverlight

Some professors are starting to show online video that requires Silverlight, browser plugin software from Microsoft.  To test for it, and to download it:

http://www.microsoft.com/getsilverlight/Get-Started/Install/Default.aspx

Outlook addins - disabling

Ho to disable Outlook add-ins:

1. On the Tools menu, click Trust Center, and then click Add-ins.
2. View the add-ins and application extensions that are categorized as follows:
• Active Application Add-ins     Lists the extensions that are registered and currently running in your Office program.
• Inactive Application Add-ins     Lists the add-ins that are present on your computer but are not currently loaded. For example, smart tags or XML Schemas are active only when the document that references them is open. Another example is the COM add-ins that are listed in the COM Add-ins dialog box. If the check box for a COM add-in is selected, the add-in is active. If the check box for a COM add-in is cleared, the add-in is inactive. To learn how to open the COM Add-in dialog box, see the section called Turn off or manage the installed add-ins.
• Document Related Add-ins     Lists template files that are referenced by currently open documents.
• Disabled Application Add-ins     Lists add-ins that were automatically disabled because they are causing Office programs to crash.

http://office.microsoft.com/en-us/outlook-help/enable-or-disable-add-ins-in-office-programs-HA010034127.aspx#BM2