Posts filed under 'Tutorials'
I have had Verizon FiOS for more than a year now and as the service areas continue to grow, with the technology’s excellent service, I’m sure a lot have signed up for it. If Verizon provides you with an Actiontec modem/router then let me advice you to purchase another router because Actiontec will drive you crazy in the long run. I have 10mbps/3mbps down/up throughput and I download a lot as in I average 1GB/day (that’s a modest number). They aren’t illegal downloads per sé because they are distributed openly (KDrama). If I have more than 3 huge files in my μTorrent (or any other bittorrent client), others in my network wouldn’t have Internet access. That’s because I have NAT running and the routing table in Actiontec is not enough to handle huge amount of traffic. Therefore, overloaded packets are dropped giving my users nil resource.
My recommended router is D-Link DGL-4100. It’s best for serious gamers. It’s easy to configure and maintain. Below is a simple diagram of my network using this technique.
Stay tuned for the step-by-step guide on doing this.
August 20th, 2008
I’m currently working with MSSQL Server 2005 and why does Microsoft have to make everything difficult? With MySQL, a multiple insert is as simple as INSERT INTO table (columns) VALUES (array of values), (another array of values), … (last array of values). This way works in MS SQL 2008, but that’s another expense.
My current assignment in the office is to export and import MS Access data into a completely different schema in MSS. I will pose a problem at the end of this entry and if someone has a solution, I would be grateful to you.
Multiple insert in MSSQL 2005 Thanks to Pinal Dave for this
USE database_name
GO
INSERT INTO table_name (column1, column2, ... columnN)
SELECT 'value1a', 'value2a', ... 'valueNa'
UNION ALL
SELECT 'value1b', 'value2b', ... 'valueNb'
...
UNION ALL
SELECT 'value1n', value2n', ... 'valueNn'
Problem: How would I do a SELECT…INSERT in the middle of an insert because one or more columns are foreign keys. That way I don’t have to verify my data before inserting. Have the machine do it for me. For instance:
USE database_name
GO
INSERT INTO table_name (column1, column2, ... columnN)
SELECT 'value1a', [SELECT...INSERT], ... 'valueNa'
UNION ALL
SELECT 'value1b', [SELECT...INSERT], ... 'valueNb'
...
UNION ALL
SELECT 'value1n', [SELECT...INSERT], ... 'valueNn'
July 23rd, 2008
I confess that each of my entry has grammatical errors and most of them are fragments. I can’t fix them because I’m too lazy to be technical and I’m very bad with fragments.
However, that does not stop me from criticizing other people. It really annoys me that people are writing just for the sake of writing in English. They don’t concern themselves of the correctness. I know a cocky bastard has said that every time he posts an entry, he has two or three people read his draft first. You don’t have to go that far, but at least be aware of the basic — spelling, tenses, and plurality. TV and music can be dangerous on the latter because Ebonics does not follow correct plurality.
If you are blogging, if you can’t properly use the basic grammar, then I suggest you write in your natural language or proofread before you publish. I’m easily disturbed when I’m reading a piece with incorrect grammar. I feel like editing everything before reading it again.
July 10th, 2008
Here I am sitting, thinking of something optimistic to write about. It’s very difficult, so here’s what I came up with…
String inputDir = "/home/user/";
String inputFile = "in.txt";
if (!inputDir.endsWith("/")) inputDir += "/";
File iFile = new File(inputDir + inputFile);
String outputDir = "/home/user/backup/";
if (!outputDir.endsWith("/")) outputDir += "/";
iFile.renameTo(outputDir + inputFile);
July 3rd, 2008
I noted here that I constantly encounter WiFi problems. After searching the web, many have said that Linux is not WiFi friendly. I guess it could be true, but I’m not converting my Eee PC to Windows. I agree that hardware drivers are very tricky when it comes to Linux and I suspect it’s causing my troubles (the connection status is forever stuck in PENDING). Well, yesterday I slightly cleaned up my drivespace and my troubles seem to have went away. However, it’s still too early to conclude. If it really is true, maybe the system is unable to connect because it has no space to store data. I’ll be monitoring this in the next two weeks.
May 21st, 2008
Manipulation of IceWM for EeePC:
nano /home/user/.icewm/preferences
May 21st, 2008
Changing file name or folder name in UNIX.
mv OrigFileName NewFileName
mv OrigFolderName NewFolderName
May 11th, 2008
Okay, as promised I will be documenting the process of installing pre-Vista OS in a SATA drive. However, I will be documenting on a specific unit: Acer Aspire M1640.
PRE-REQUISITES:
STEPS:
- Copy all contents of the Microsoft Windows XP/2K3 in a local drive (i.e. C:\tmp\os).
- Extract the contents of the driver (Pre-req#2) in a local drive (i.e. C:\tmp\drv).
- Run nLite and follow the images below:
- Burn the .iso image into a blank disc.
- Insert the finished disc into the Aspire drive and install the operating system. Voila!
Another source: http://paparadit.blogspot.com/2007/06/installing-sata-hard-drive-with-windows.html
May 2nd, 2008
I’m not a UNIX guru, so I can’t really memorize all commands. When upgrading my Wordpress version, I only run four lines of commands, but I can’t remember the parameters. Today, I was in the mood to write a simple bash shell script so that next time all I have to do to upgrade my site are: backup, run the script, relax… The script does not backup data and design files. If you are to use the code, make sure to backup before running the script. Check out Wordpress for backup solutions.
#!/bin/bash
#
# Wordpress Upgrade Script
# Author: Alfonso Varon
#
# PRECONDITION: Data & design backup should have been done.
#
echo “Warning!!! Backup design files and data before proceeding…”
echo -e “\n”
echo -e “Let’s begin…\n”
echo -n “Which site would you like to update ([1]=arot, [2]=sol): ”
read -e SITE
setterm -background $SITE
if [ $SITE -eq 1 ] # upgrade ARoT
then
echo “Changing to A Record of Thoughts directory…”
cd ~/public_html
elif [ $SITE -eq 2 ] # upgrade SoL
then echo “Changing to Sapian Online’s directory…”
cd ~/public_html/xxx
fi
echo -e “We are currently in directory:”
pwd
echo -e “\n”
echo -e “Downloading the latest version of Wordpress…”
wget http://wordpress.org/latest.tar.gz
echo -e “Done.”
echo -e “Unzipping the package…”
tar -xzvf latest.tar.gz
echo -e “Done.”
echo -e “Upgrading…”
cp -rpf –-reply=yes wordpress/* ./
echo -e “Done.”
echo -e “Cleaning…”
rm -rf ./wordpress
rm latest.tar.gz
echo -e “Done.\n”
echo -e “Wordpress files have been upgraded. Go to the administration
panel for further upgrade instructions.”
April 5th, 2008
Eee PC comes with XandrOS distro of Linux, therefore the way I access my network files is different than when I’m using Windows. Fortunately, there is a system called the Network File System (NFS). First generation of WD Netcenter are NFS enabled, but my recent acquisition — the MyBook World Edition — is not NFS enabled. Therefore I have to do the dirty work before I can access my audio/video files from my half-terabyte hard drive. The following are the steps I went through before successfully accomplishing the task:
- SSH Access in MyBook WE
- MyBook WE as NFS Server
- Mount the path:
mount mybook_ip:/shares/internal /mnt -o rw
That’s all folks!
December 23rd, 2007
Previous Posts
