When the clipboard doesn't work across Remote Desktop

Every now and then, when I have a remote desktop connection open, the clipboard fails to copy across the sessions.  It's usually the remote to local copy that's borked.  It's pretty easy to fix, but I can never remember what I need to do to fix the connection.
Fortunately the Terminal Services Team Blog has got that covered.  Just kill and restart the rdpclip process in the remote session.   There was also a part two to that post that was pretty interesting.
[Edited on 1/30/08]
There is a command line way of resetting rdpclip, so you can roll up both steps as a batch file

taskkill /IM rdpclip.exe
rdpclip.exe

Source: http://anotherlab.rajapet.net/2008/01/when-clipboard-doesn-work-across-remote.html 

Enable concurrent remote desktop connections in windows 7

We have 1 main pc in our house which holds all the data and applications.  A number of older laptops and desktops then use Remote Desktop Connection to connect to the main pc.  The problem of course is that windows xp, vista and 7 have only allowed 1 user to be connected to a pc at once.  This sucks and in light of Linux competition should have been fixed by now.  To get this sort of functionality in windows you need to use a server edition.
However, this can be patched to allow as many people as you like to connect to different user account on the same PC at the same time… hence Concurrent RDP.
To achieve this download this file which will work with Windows 7 Professional.

Windows 7 Remote desktop patch (locally hosted)
see here for alternative download location
Extract,
Right Click on the file “install.cmd” and select “Run as Administrator”
You will then see a screen explaining that all went well.
This method was created by the good folks on the Winmatrix forums so pop over there for more details should you need them. The missingremote.com have more details and some screen shots if you need more help.
Rumour has it that this can also work on windows home premium.. look here for details

Source: http://dx3webs.com/wordpress/2010/01/enable-concurrent-remote-desktop-connections-in-windows-7/

How does one add a day/hour/minute/second to a date value?

The SYSDATE pseudo-column shows the current system date and time. Adding 1 to SYSDATE will advance the date by 1 day. Use fractions to add hours, minutes or seconds to the date. Look at these examples:

SQL> select sysdate, sysdate+1/24, sysdate +1/1440, sysdate + 1/86400 from dual;

SYSDATE              SYSDATE+1/24         SYSDATE+1/1440       SYSDATE+1/86400
-------------------- -------------------- -------------------- --------------------
03-Jul-2002 08:32:12 03-Jul-2002 09:32:12 03-Jul-2002 08:33:12 03-Jul-2002 08:32:13

The following format is frequently used with Oracle Replication:

select sysdate NOW, sysdate+30/(24*60*60) NOW_PLUS_30_SECS from dual;

NOW                  NOW_PLUS_30_SECS
-------------------- --------------------
03-JUL-2005 16:47:23 03-JUL-2005 16:47:53

Here are a couple of examples:

Description	Date Expression
Now	SYSDATE
Tomorow/ next day	SYSDATE + 1
Seven days from now	SYSDATE + 7
One hour from now	SYSDATE + 1/24
Three hours from now	SYSDATE + 3/24
An half hour from now	SYSDATE + 1/48
10 minutes from now	SYSDATE + 10/1440
30 seconds from now	SYSDATE + 30/86400
Tomorrow at 12 midnight	TRUNC(SYSDATE + 1)
Tomorrow at 8 AM	TRUNC(SYSDATE + 1) + 8/24
Next Monday at 12:00 noon	NEXT_DAY(TRUNC(SYSDATE), 'MONDAY') + 12/24
First day of the month at 12 midnight	TRUNC(LAST_DAY(SYSDATE ) + 1)
The next Monday, Wednesday or Friday at 9 a.m	TRUNC(LEAST(NEXT_DAY(sysdate,''MONDAY' ' ),NEXT_DAY(sysdate,''WEDNESDAY''), NEXT_DAY(sysdate,''FRIDAY'' ))) + (9/24)

Source: http://www.orafaq.com/faq/how_does_one_add_a_day_hour_minute_second_to_a_date_value