Teamviewer - Free Remote Desktop apps

TeamViewer is the fast, simple and friendly solution for remote access over the Internet. It can even bypass firewall as it uses http tunneling. It enable remote access, remote presentation, traning, file transfer, chat and more.

Cost: Free for non-commercial use.

For more information, go to TeamViewer website.

Scenario:
Bob tries to remotely view/control Susan's machine for virus troubleshooting.

What to do?
For Susan

• Download the TeamViewerQS and run it (Click on the link to download).
• Tell Bob the session id and password (depicted as the screen below).
• 

For Bob

• Download TeamViewer (full version) and run it.
• Connect using the session id and password provided by Susan.
  

C# How to parse date string into UK date format

DateTime ukdatetime = DateTime.Parse(usdatetime, System.Globalization.CultureInfo.CreateSpecificCulture("en-GB"));

Oracle PL/SQL SubQuery example

The following subquery uses EXISTS method to check whether the employee work in UK site. The crucial part of the query is the use of the usr.idemployee (main query) to filter the data in the subquery.

The subquery could be selecting from any tables but the query result is appended to the main query. The subquery result doesn't have to exist in any table.


select usr.iduser, usr.name,
DECODE ((SELECT 1
FROM DUAL
WHERE EXISTS (
SELECT dummy
FROM empworkplace wrk
WHERE usr.idemployee = wrk.idemployee
AND wrk.sitekey = 'UK'),
NULL, 0,
1
) AS fromUKSite,
from users usr.