Sunday 22 April 2012

India Post's gold offer for Akshaya Tritiya


For those who are eager to bring wealth and prosperity to one’s doorstep, going by the new-found aura of Akshaya Tritiya, India Post is all set to create avenues for investment in gold coins. And to make the option really attractive for customers, a six per cent discount is being offered on purchases.

On Akshaya Tritiya, which falls on April 24, buying gold is an important part of the worship of Lakshmi, the Goddess of Wealth. India Post is offering the special discount on gold coins of any denomination purchased through post offices during the period from April 1, 2012, to June 30, 2012. The coins are manufactured by the world-renowned Valcambi SA, Switzerland.

SQL: Query to find Duplicate Rows in a Table


If you would like to list duplicate rows with the count for a table, the following query would be helpful.
Query: Duplicate Rows

SELECT Column1,Column2,Column3,Count(*)
FROM dbo.TableName
GROUP BY Column1,Column2,Column3
HAVING ( COUNT(*) > 1 )

And there are scenarios where we need to find the combination of Columns in a table occurred only once. In such case the following query could be used.

Query: Unique combination of columns

SELECT Column1,Column2,Column3,Count(*)
FROM dbo.TableName
GROUP BY Column1,Column2,Column3
HAVING ( COUNT(*) = 1 )

Hope it helps.
Source : http://sapost.blogspot.in/

Repair Internet Explorer with Fix IE Utility


We are pleased to release the Fix IE Utility v 1.0. This freeware portable utility re-registers all the concerned dll & ocx files required for the smooth operation of Internet Explorer.





Simply extract the contents of the .zip file and run the  utility.
If you face any problems while running IE, maybe after recovering from a malware attack, and if you find that the Reset Internet Explorer feature does not help you, run this tool to re-register around 89 dll & ocx files, which are required for the smooth running of Internet Explorer.
Fix IE Utility has been tested on IE 7, IE 8 and IE 9, on Windows Vista & Windows 7.  Before running the utility, make sure that all your Internet Explorer windows are closed.
Courtesy : www.thewindowsclub.com & http://sapost.blogspot.in/

How does a wireless mouse work when even it is not connected to any other devices?

 How does a wireless mouse work when even it is not connected to any other devices?

In the wireless mouse the information from the mouse to the CPU and back are exchanged through radio signals
A mouse is a very important peripheral device in a computer which is used to move the cursor on the computer screen. It has several other buttons which are used to highlight a part of text, images or other information, to scroll pages, to click and open files, folders etc.


In case of a wired mouse, the information from the mouse to the CPU and back are transmitted through a pair of wires. In case of a wireless mouse, these information are exchanged through radio signals.

To support this arrangement, there is a radio transmitter in the mouse and a corresponding receiver in the computer.

The radio frequency receiver receives the radio frequency signals, decodes them, and then sends these signals directly to the computer as normal. RF receivers usually come as built in components that connect to the mouse input. In some cases a separate card is installed in the computers.

Most wireless mice have integrated receivers that plug into a computer's peripheral input and are very small in size. Wireless mice mainly use radio frequencies at 2.4 gigahertz and at these frequencies a mouse can transfer data at very quick speed. Also there is very little or no interference in a work or home environment.
They also have a good range of the order of 100 feet or so. Another technology that is used in wireless mice is Bluetooth RF technology. It uses 2.4 gigahertz frequencies. Bluetooth also has a decent range, usually about 20- 30 feet.

S.P.S. JAIN
Former Member, Engineering, Railway Board
Indian Railways
Gr Noida, Uttar Pradesh

Courtesy : thehindu dtd 18/04/2012

NOTE PAD TRICKS &TIPS

Note pad is a default text editor software in windows. Usually note pad is used to note some important information’s (which not require any stylish fonts/presentations-just to note some thing).But with this simple text editor we can do various things. Most of these things are unknown to many of us. Some tricks are displayed below.
Note Pad to check the status of Anti virus

Note pad files can be used to check the status of anti virus software. We can check whether the anti virus software worked properly or not with notepad
Copy the below code
X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*
(official name: EICAR Standard Anti-Virus Test File)

Open the note pad
Paste the code
save the file with code extension .exe with some name
If your anti virus software is active when you save the files the anti virus software will detect the file and attempting to delete the file
This shows your anti virus is effective , if not try another anti virus


Note Pad Trick(World Trade Centre Trick)

The Flight number that attacked the World trade centre on 11 September 2011 was Q33NY
Just open the note pad
Type the Flight number Q33NY in capital letters
Go to Format ---Select the font

Change the Font to “Wingdings” and size to 72
Just see the note pad












Use Note Pad as Log book/Personal Diary
You can use the Note pad file as Log book/ Personal Log Diary . To use note pad as log book
just open the notepad
write .LOG and save and close it
Then reopen the note pad and see the magic
The current date and time in the computer are automatically save to the log file



Constantly Repeat the Messages

You can constantly repeat the messages with note pad this is by using save the note pad file with extension .bat. The below tips will create infinite number of cycles/repeat the message in your computer. Follow below steps

Open Note pad

Copy the the code and paste it in note pad

@ECHO off
:Begin
msg * Hi
msg * This is SA PARAVUR?
msg * For all System Administrators!
msg * Please follow us http://saparavur.blogspot.in !
msg * for new tips and tricks and news
GOTO BEGIN

Save the file with any name but with the extension .bat. That is save as saparavur.bat
after that open the file (by double clicking on it)
and see what happens

via-sa paravur.blogspot

Rates of Dearness Allowance applicable w.e.f. 01.01.2012 to the employees of the Central Government and the Central Autonomous Bodies continuing to draw their pay in the pre-revised scale as per 5th CPC

 
No. 1(3)/2008-E.II (B)
Government of India
Ministry of Finance
Department of Expenditure

North Block, New Delhi
Dated: 20th April, 2012

OFFICE MEMORANDUM

Subject:- Rates of Dearness Allowance applicable w.e.f. 01.01.2012 to the employees of the Central Government and the Central Autonomous Bodies continuing to draw their pay in the pre-revised scale as per 5th CPC
The undersigned is directed to refer to this Departnent’s O.M. of even No. dated 17th October, 2011 revising the Dearness Allowance w.e.f. 1.7.2011 in respect of the employees of the Central Government and the Central Autonomous Bodies who continue to draw their pay and allowances in the pre-revised scales of pay as per 5th Central Pay Commission.

2. The rates of Dearness Allowance admissible to the above categories of employees of the Central Government and the Central Autonomous Bodies shall be enhanced from the existing rate of 127% to139% w.e.f. 01.01.2012. AIl other conditions as laid down in the O.M. of even number dated 3rd October, 2008 will continue to apply.
3. The contents of this Office Memorandum may also be brought to the notice of the organizations under the administrative control of the Ministnes/Departments which have adopted the Central Government scales of pay.
4. Hindi version is also attached.

sd/-
(Subhash Chand)
Deputy Secretary to the Government of India

Source: www.finmin.nic.in
[http://finmin.nic.in/the_ministry/dept_expenditure/notification/da/da_order_cab01012012.pdf]

Get old look to Gmail


If you have given new look to your Gmail account and it is now irritating you, eager to have that good old look but not finding option, please login to your Gmail account and click the link below.
Have old Look


To get this old look as and when you need it ,in Firefox-Bookmark your old look inbox
In Internet Explorer-Add old look inbox to Favorites.
First login to your Gmail.You will get new look.Then click Bookmark or Favorite.You will be taken to Old Look.

via-do putter

MODEL QUESTIONS FOR IPO & PM GRADE 1 EXAM (Q-101-125)

(Postal Manual Volume V Qn 101-125)
101.    An unpaid letter addressed to a place of in foreign should be
            a)         Returned to sender                                     b)         Send to RLO
            c)         Forwarded to the office of exchange in separate bundle
            d)         None of these                                                                                          Ans: d(110a)
102.    Book of postmark used for taking the impression of round MO, oblong MO and unpaid  stamps should be kept
a)                 In the personal custody of the postmaster
b)                 In the custody of the Assistant Postmaster(Mails)
c)                  In the custody of Mails PA
d)                 In the custody of treasurer                                                                                     Ans:a(103)
103.    Insufficiently paid outward foreing letter can be taxed only by
            a)         Office of Posting                                          b)         Sorting PA of the office
            c)         Office of foreign exchange                                    d)         RMS office            Ans:c(110a)


104.    If an UR article is received in open and torn condition at the office of delivery,
            a)         Returned to RLO
            b)         Returned to the sender
            c)         Entrusted to postman for delivery enclosed in a protected cover
            d)         None of these                                                                                               Ans: c(114)
105.    At the office of delivery, an unregistered article of the letter mail addressed to more than on person is
            a)         Delivered to any one of the addresses
            b)         Returned to Sender
            c)         Delivered to any one of the addresses but in the order in which the name
                        appear on the cover
            d)         None of these                                                                                               Ans:c(117)
106.    Sanction of ‘recall of article’ to return the article to the sender or to alter/correct the address will be issued by
            a)         Divisional Superindent                   b)         PMG
            c)         Sub divisional Head                                    d)         Head/Sub Postmaster     Ans: a(148)
107.    Weighment System bags are carried through
            a)         By bus                                                            b)         By train
            c)         By mail Runner                                            d)         None of these           Ans: b(226)
108.    If the Regd article is insufficiently paid , the difference of postage will be collected from
            a)         The addressee                                             b)         The sender
            c)         The regn counter PA of o/o booking        d)         PM of o/o booking    Ans: c(99)
109.    When the addressee of a damaged insured article refuses to take delivery
            a)         The article should be returned to the sender duly protected in a pro bag
            b)         Police complaint to be lodged
            c)         Reported to Divisional office for further order
            d)         Returned to RLO                                                                                          Ans: a(196)
110.    Facsimile impression of signature on an acknowledgement
            a)         Can be accepted                                          b)         Cannot be accepted
            c)         Discretion of the PM                                    d)         None of these           Ans:a(146)
111.    Due mail and sorting list a particular PO is issued by
            a)         The PM of the concerned PO                    b)         Sub divisional Inspector
            c)         The supdt of Post office concerned         d)         ASP                            Ans: c(136)
112.    If in course of transmission of parcel it is noticed that the parcel contains more than one written communication of the nature of a letter of having the character of  a personnel communication the parcel should be
            a)         Returned to sender with suitable remarks
            b)         Taxed as I class and sent to the destination
            c)         Endorsed ‘for open delivery’ and fwd to destination for arrangement  open
                        delivery
            d)         None of these                                                                                               Ans: c(88)
113.    Articles registered in a PO for delivery from the office itself should be
            a)         Entered in a station registered list and kept for following days delivery
            b)         Dispatched to the local RMS mail office for further delivery
            c)         Dispatched to HO for further disposal
            d)         The letter should not booked.                                                                    Ans: a(90)
114.    A direct parcel bag is to be closed a delivery PO where the number of Regd. Insured parcel is
            a)         Three or more                                               b)         Severn or more
            c)         Ten or more                                                   d)         Five or more              Ans: d(91)
115     Maintenance of insured check sheet by sorting mail office may be relaxed by
.           a)         The Supdt of RMS                                       b)         Head of the circle    
            c)         By the D section of the directorate            d)         None of these           Ans: b(96)
116.    In the case of redirected parcels on which redirection fee is recoverable from the addressee if any incorrect fee had been made entry
            a)         The parcel should be returned to the sender with remarks
            b)         The parcel Assistant who noticed the irregularity can make necessary
                        correction  and send the parcel for onward submission
            c)         The parcel assistant should bring the fact to the notice of the postmaster who                   should correct it under his initial
            d)         None of these                                                                                               Ans: c(99)
117.    Suspected cases of reuse of used stamps on the article received in transmission from BO should be reported to
            a)         The supdt of Post office                              b)         The Head Post offices
            c)         The sub divisional Inspector                      d)         None of these           Ans: c(99)
118.    Mark the correct option
a)         In case of inward Foreign article if postage stamps which are not cancelled by the o/o origin received, it should be cancelled by a thick stroke in ink.
            b)         UR articles of the letter mail posted bearing no postage stamp should be                           impressed on the back with the stamp
            c)         Late letters posted in RMS letter boxes on which a late fee has not been paid                   should be impressed on back with the ‘Detained – late fee not paid stamp’
            d)         In HOs the station articles of the letter mail received on which postage due                                   should be impressed on the back with the PMs unpaid stamp only
            e)         All the above                                                                                                 Ans: e(107)
119.    Mark correct option
a)         If an article the regn of which is compulsory if found in a letter box after the closing of the counter, it should be kept in deposit till the office is next open for registration
            b)         Unpaid article addressed to officials of postal dept, it should be taxed with the                  postage in the usual way, treated as refused and sent to RLO.
c)         If an UR article found open in sorting should be protected by enclosing an envelope with a remarks written on a cover ‘ received open’ and dispatched to destination
            d)         The article posted in India having affixed with foreign postage should not be                    recognized in payment of postage or other postal charges.
            e)         All the above                                                                                                 Ans: e(115)
120.    Unpaid and insufficiently paid article other than letter and postcard for foreign countries received in posting
            a)         Should be forwarded to RLO
            b)         Should be forwarded to the office of exchange .
            c)         Should be returned to the sender for delivery on recovery of an amount equal
                        to double the deficiency at inland rate
            d)         None of these                                                                                               Ans: c(110)
121.    Postcard manufactured privately which are either thicker or less flexible than the departmental inland postal card.
            a)         Should be allowed to pass unchallenged
            b)         Should be refused transmission
            c)         Should be returned to RLO
            d)         None of these                                                                                               Ans: a(112)
122.    Mark the correct option
a)         Any goods transmission through inland post is prohibited found in PO should be detained and an immediate report submitted to Head of the Circle/Region.
b)         If a leaky parcel is detected in a PO or transferred to it by a section or a mail office should be detained and a report should be made to the SPOs/Istclass PM for order
c)         If in a PO article being opened are found to contain opium or allied drugs should be made over its all contents to the nearest Excise officer for further proceeding
d)         Any article passing through the PO suspected that the article contain  any thing  is prohibited  by inland post should be forwarded in a cover and marked ‘doubtful’ addressed to the Postmaster of destination
e)         All the above                                                                                     Ans:e(122,123)
123.    Mark the correct option
a)         The due mail and sorting list for PO and mail offices in communication with offices         in more than one RMS Dn are prepared  and supplied by the Head of the circle
            b)         The due mail and sorting list for PO in direct communication with a mail office in                         one RMS Dn will be issued by the Supdt of RMS concerned
c)         Village sorting lists are prepared and supplied to Head, Sub and Branch office by Sub divisional Inspectors.
            d)         All the above                                                                                                 Ans:d(137)
124.    If an article is found franked by a person who is not entitled to the privilege
            a)         Returned to sender with remarks  b)         Article detained & Report to SPO
            c)         The frank should be ignored and the article should be taxed with the postage
            d)         None of these                                                                                               Ans: c(125)
125.    In the event of an error in a mail list and when a revised or corrected mail list  is received
            a)         The revised document can be kept safely in the correspondence file
            b)         The revised document can be substituted by removing the earlier one
            c)         Both the list s should be retained on record attached to each other a note being               added on the original
            d)         The error mail list should be returned to sender                                                Ans:c(128)
(Prepared by AB Kantharaja  Mobile No 08969822340