Home
Mapping Drive via RDP RDC
- Details
One of the most common tasks you'll need to do when using an RDC is transfer a file from your local machine to the remote machine that you're logged into. In the past I would open a new file share on the local machine and browse to it from the remote one. Or maybe I'd map a drive using NetBios.
But not anymore! Microsoft's RDP Client has a sweet little feature that will connect your local hard drives to the remote machine when you open a RDC.
How to do it!
First, open the Microsoft Remote Desktop Connection (Start -> All Programs -> Accessories -> Communications -> Remote Desktop Connection). Then click on the Options button and go to the Local Resources tab. The bottom section of the tab is titled Local Devices, and there you will see a check box labeled Disk drives. Checking this box will automagically connect all disk drives on you local machine to the remote machine when you open the RDC.
When you get logged into the remote box, open My Computer and you'll see that all the drives (hard drives, floppy drives, CD/DVD ROM drives, and even mapped drives) will show up as mapped disk drives. Sweet!
Go ahead and open one of the newly mapped drives and transfer files to your heart's content. Now, how easy and painless was that!
Connect to MS SQL Server
- Details
How to connect to a MS SQL Database with MS SQL Manager.
First Whitelist your IP address you can get your IP by clicking here: MyIp.ourace.com [new window] this is your External IP not a 192.x address
- Login to Plesk.
- Click Websites & Domains tab at the top.
- Click SQL white list beta? icon (last icon seen).
- Click Add IP, select service and type IP; Click OK.
-or-
Click Add my IP then select service.
Click connect to manage your Database. Also you might see a lot of Databases so you will need to find yours.
MySQL replace string in table row
- Details
My SQL replace strings with other string in a table
So you want to go through all your content in lets say Joomla and replace a string or character with something else.
Lets say you have french characters and want to replace with the html entity version.
UPDATE `jos_content` SET `introtext` = REPLACE(`introtext`, 'À','& Agrave;');
UPDATE `jos_content` SET `fulltext` = REPLACE(`fulltext`, 'À','À');
Formula:
UPDATE TableName SET TableColumnName = REPLACE( TableColumnName , 'Find Me','replace with this');
Set Up a PPTP VPN on Ubuntu Server 10.04
- Details
Page 26 of 40