How2Labs

Sunday, January 13, 2013

1 How to make SanDisk USB Bootable windows 7

Few days back i needed to format my Laptop , but i didn't had windows disk so i decided to go for USB Boot . i tried so many times by formatting disk into NTFS and copying all windows 7 files in USB drive but nothing worked . finally i searched all over net and found a solution which worked for me . so here it is .

Step 1 : backup all your USB data because its gonna format this.
Step 2: goto run type cmd and run command prompt as administrator.
Step 3: Now type all the commands as it is shown .
Step 4: type diskpart and hit enter
Step 5: type list disk . it shows the list of disks. make sure you able identify your USB drive (see the size and free space).
Step 6: type select disk # (where # represents your disk number , for me its 1)

from step 4 to 6

Step 7: type clean (Clean : removes any existing partitions from the USB disk, including any hidden sectors)
Step 8:type Create Partition Primary (it Creates a new primary partition with default parameters)
Step 9:type Select Partition 1 (Focus on the newly created partition).
Step10: type Active (Sets the in-focus partition to active, informing the disk firmware that this is a valid system partition)
Step11:Format FS=NTFS (Formats the partition with the NTFS file system. This may take several minutes to complete, depending on the size of your USB key.)
Step12:Assign (Gives the USB drive a Windows volume and next available drive letter, which you should write down. In our case, drive “J” was assigned.)
Step13:Exit (Quits the DiskPart tool)
Step 14 :Now go into the directory where you copied all your windows 7 files ( in command prompt ). open boot directory(cd boot) . and type the command as

Bootsect.exe /nt60 J: (where ‘L’ is the drive letter assigned to your USB key from the previous step)
Bootsect infuses boot manager compatible code into your USB key to make it a bootable device.

Now copy all windows 7 files to USB drive , no need to use command prompt you can do it using copy paste option. Have fun installing windows.

0 Slice of SQL

database sql tutorial

Wanna learn sql ? in a different way . lets try this.
Once there was a quy who went shop and said “ give me few chocolates “. Shopkeeper sais do you have basket he said no .shopkeeper said go and bring the basket . he just created a basket . in database our basket is the TABLE and we can create it by using this following statement.

SQL> create table basket(name varchar2(20),price number(4),quantity number(2));
(Output:>)Table created.

In above query > basket is the name of table .
name is the column of type character of length 20 .
price is the column of type number of size 4
quantity is the column of size 4.
After getting the basket he again went to shop and said give me 5 dairymilk,4 5star and 3 perk in this basket . we can do this in database by “insert command”

SQL> insert into basket(name,price,quantity) values('dairy milk',20,5);
1 row created.

We can even do this in a simple way .

SQL> insert into basket values('5star',10,5);

1 row created. (note: to use this all values need to be entered )
Now he just wants to crosscheck the basket so he checked the chocolates in basket similarly we can do this by using the “SELECT command”

SQL> select * from basket ;
NAME                      PRICE   QUANTITY
-------------------- ---------- ----------
dairy milk                   20          5
5star                        10          5
perk                         15          3

where * indicates all the column
Now when he was going to meet his girlfriend ,he met with his friend and he took some chocolates from his basket. Now he just wants to confirm the number of 5star chocolates availbe so he counts the 5star chocolate. We can also do this in database using following command.
SQL> select name,quantity from basket where name='5star';
NAME                   QUANTITY
-------------------- ----------
5star                         5

Finally he meets with his girlfriend and gave basket to her. After going home the girl checks the basket and counts the number of types chocolate given by the guy. In database we use “Aggregate functions” for this .

SQL> select count(name) from basket;
COUNT(NAME)
-----------
3

From this tutorial what we learned is

Creating a table : create command.

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

Inserting values in table : insert command

INSERT INTO table_name
VALUES (value1, value2, value3,...)
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Selecting or viewing the rows : select command

SELECT column_name(s)
FROM table_name
Or
SELECT *
FROM table_name

Selecting specific rows on conditions : where clause

SELECT column_name(s)
FROM table_name
WHERE column_name operator value
Operator and their meanings

Operator	Description
=	Equal
<>	Not equal
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	To specify multiple possible values for a column

Counting the number of rows: Aggregate function- count

Useful aggregate functions:

AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum

0 Remote control the Browser Window

Ajax framote sharing tech

FRAMOTE

Someone said that Big surprises comes in small packages . Today i feel this line perfect for that framote . This is an awesome example of Ajax and iframe shown by Jaime Caballero .

What it is ? and how it works ?

framote enables you to control the remote browser and show the links which you want. You just need to give a starting URL(link) and it will provide you two different URL's (i). to share on remote devices (ii) to control those remote devices .

Where you can use this ?

This will be specially useful for the web Developers by using this they can test their applications on different browsers and multiple devices without opening the whole web on each of them one by one. yippee its free.

How to Use Framote Step by step

Step 1: go to framote and give a URL i say "http://www.how2labs.info/" and click create.

Step 2: share the Framote URL and open Control URL in a new window to control the Framote URL

framote in action

Step 3: in Control URL provide the new URL you want to share and click change. the remote url will automatically get refreshed

change remote url framote

Step 4: Don't forget to subscribe for new update :)

0 A Presentation Worth Watching For Software Testing Professionals

cross platform software Testing

Software Testing matters a lot specially when you are working on a cross platform software or service.Here i am going to provide a latest example of that "what are the challenges you need to face when you work on cross platform software." This presentation is actually prepared by John Resig and it talk about challenges crossed when testing mobile JavaScript. if we highlight the important things we will know that you need to collect a lot information before starting up things including the testing platform and environment.

Testing Mobile JavaScript from jeresig

2 Learn The ART of Programming

problem solving programming

Programming is an Art of problem solving. All good programmers love the programming and they will do this passionately that’s why they became good programmer and mastered this art.

If you want to be a good programmer you need to give your 100% and you have to start thinking logically.

Things to be taken care before Solving a Problem:

1. Read the problem carefully and try to understand what is all about and what should be the final outcome/solution.

2. Don’t get tensed by thinking that problem is very tuff and I can’t solve it, be positive.

3. Don’t Ever try to solve the problem in single shot do it step by step (if don’t know the solution or how to solve it).

Let’s give it a Hit

Problem : you need to draw the shape given below

***

*****

*******

Solution Approach:

If you see this problem carefully you can see that you have to draw the starts such that ,the number of starts in each line is 2n-1 i.e. (2*1-1=1,2*2-1=3..).

You also need to take care of space before the stars so it should form a pyramid.

So now you can see that problem is divided into two sections

draw space
draw star

- - - *

- - ***

- *****

*******

So this is the way you should solve the problems .

If still have doubts you can ask here. Feel free to drop your comments

0 Share your Files using Torrent

file sharing step by step tech utorrent

Now a days there are lot of websites for sharing your files but still the process become hectic if you are a new-bee or even professional .there is an easy way to share your files using the utorrent . I said easy because you need not to login or upload the file on website , you just need to drag and drop the file or folder on utorrent and it will give a link that you can share with your friends. Here i am going to show you how easy it is to do .

Step 1 : select file or folder and drop it to utorrent .

drag and drop

Step 2: click on Get Link button. it will create a link for sharing your files

Get Link

Step 3: now copy the link by clicking copy link button.

copy link

Step 4 : share link with your friends and you are done.

Steps to be followed by the person to download the files

Step 1: paste the given link in address bar of browser

Step 2: if you have you utorrent or any other torrent client copy the magnet link otherwise just click on download button.

copy magnet link

Step 2: now we copy the magnet link so we add it to our torrent client.

Add torrent from URL

Step 3: now paste the magnet link and click ok button.

step 4: now your download will start. enjoy downloading and file sharing :)

downloading

0 Boosting up your COMPUTER STARTUP

services tech tgmc tgmc 2012 windows

Is your computer or Laptop takes time during start-up after you installed few heavy softwares ? Don't worry there is way you can decrease your computer start-up time .before we go down lets understand how it works.
Whenever you install software like oracle,DB2,SQLServer,Apache etc. they will install there services which will be started every time you turn on your pc,like when you install oracle it will add few services given below.

OracleDBConsoleorcl
OracleOraDb10g_home1TNSListener
OracleServiceORCL

so what we gonna do then because these services are essential to use the products ? so what we do is we disable these services to start on system boot ,and whenever we need then we start them manually. But this will become hectic to type the command every time so what we gonna do is we will make a batch file for this task .and when ever we need them we will make a single click.

Disabling services from getting started on system boot.

click on start button
type cmd right click and run as administrator
Command Prompt will popup as shown.
type net start all the service list is shown just note down the services name you want to disable and set the startup to manually .
Now open Notepad
for every service type following command sc config service-name start= demand (note the space between = and demand)
save file as set_servicemanual.bat (in file type select as all files)
Run saved file as administrator
for our example Notpad file looks like

sc config OracleDBConsoleorcl start= demand
sc config OracleOraDb10g_home1TNSListener start= demand
sc config OracleServiceORCL start= demand
pause

Creating the Batch file for manual starting services

open notepad
for every service type command as net start "service name"
save file as start_servicemanual.bat (in file type select as all files)
Run saved file as administrator
for our example Notpad file looks like

net start "OracleDBConsoleorcl"
net start "OracleOraDb10g_home1TNSListener"
net start "OracleServiceORCL"
pause

2 Windows Phone Facebook Chat not connecting : Solution

facebook tech windows phone

I have Nokia Lumia710 and recently i faced a problem that is my Facebook chat is not working. it is always showing trying to connect.

So i just searched over the internet but there is no solution available so i tried something and i got the solution.

if you are facing the same problem follow these steps.

go to SETTINGS->EMAIL+ACCOUNTS-> DELETE YOUR FACEBOOK ACCOUNT.
Now again add your Facebook account. it will ask you to allow chats say ok . if it get connect then enjoy otherwise follow the 3rd step.
go to Messaging->click Settings -> turn on Facebook chat it will ask you to setup the chat allow it . this time it gets connected enjoy have fun :).
please drop your valuable comments .

0 Increase your websites performance using Google PageSpeed

page speed performace tech website website optimization

Websites loading speed plays a major role in popularity of the website.A website with good content but taking a lot of time to load in such a case users may reject that website and won't like to visit again.

So now a days web developer and owner spends a lot on the optimization of the websites.but there is an easy way available now.

Google launched a service that delivers a web pages with optimization and takes minimum time to load,currently the service is in beta version and available free and pricing is not yet decided .

What is Google PageSpeed Service ?
Page Speed is an online service to automatically optimize and loads page with speed.
How it Works ? PageSpeed fetches the content from your website and delivers to users by google servers after optimizing them using best web performance practices.
How can I use it ?
i. Sign Up and provide your serving and reference domains.
ii. Send your traffic to PageSpeed Service by pointing your DNS CNAME entry to ghs.google.com.
Try yourself
1. Go to http://www.webpagetest.org/compare
2. Enter the URL of your website, say www.example.com.
3. Click the Start Test button.