Saturday, January 2, 2021

Hypothecation termination of Vehicle on Parivahan:

- It is faceless service - you don't need to visit RTO for removing Hypothecation. Just pay 200 Rs fees online and upload all mandatory documents (marked with asterisk(*)) online on parivahan.gov.in, especially Form 35 and/or NOC received from Bank at vehicle loan closure.

- It takes little more than 1 month from the date of online submission of documents till the new RC is received at home.

- RTO staff verified the documents after 18-20 days after payment of fees and submission of documents online. During this period, you need to have patience, as there is no status update on your application. Don't run to RTO for inquiring. 

- Dispatch of Smart RC Card was done by Indian Post. There was no tracking number of it, but it came within 3-5 days after you see the dispatch status. 

- You don't need to submit old RC smart card. You can destroy it yourself, once you receive new RC smart card with Hypothecation information removed.

- Posting few images of my application for your reference.

 


 
 



Saturday, November 28, 2015

Xolo Service Centres in Pune

Xolo Service Centres in Pune

1) AVS Computer Technologies,
171, Somwar peth,
Naveen Appt,
Opp. Nageshwar Mandir
Pune - 411011
Mo - 9371018937/9595051007

2) SiddhiVinayak Enterprises,
Pathak Park,
Office no 8,
3rd floor, Near Sharda Centre,
Behind Kalyaan Jewellers,
Nal Stop, Pune
Contact - 02065006721/9823631721

Friday, November 11, 2011

Preparation for exam 70-433: SQL Server 2008 Database Development

Below is the list of books that I used for preparing exam 70-433:

1. MCTS 70-433 by Microsoft Press
2. The Real MCTS 70-433 by Syngress publication
3. SQL Server 2008 Bible by Wiley publishing

I have zipped them for your easy reference, the URL of which is here.

I have around 5 years of experience working with SQL (2000, 2005, 2008), most of which was SQL 2005. I decided to upgrade my skills for SQL 2008 and started by reading MCTS book by Microsoft. I also read 'The Real MCTS' book. Some chapters were good in 'MCTS Microsoft', some in 'Real MCTS'. I used 'Bible' for referring new concepts like change data capture and CDC which I had not worked in the past. It explains them well giving tabular explanation.

I gave my exam on 11/11/11 and scored 100%. I must also give due credit to www.examcollection.com wherein I found dumps for exam 70-433. You need to get VisualCert Exam manager software for going through the questionaire. The software is almost similar to real exam. In any given dump, there are around 155 questions. The real exam asks 55 question, but you must go through their dumps. Almost all questions came from those dumps except 3-4 questions.

This is my bifurcation on different sections:

1. XML - MCTS Microsoft (for xml raw, auto, path (skip explicit), methods like value, nodes, query) + Real MCTS (openxml)
2. Spatial, Full text search, service broker - MCTS Microsoft (service broker mainly high level topics like message type, queue, contract, service)
3. database mail, powersheel, data change, CDS, audit - MCTS Microsoft
4. ranking functions - Real MCTS
5. error handling - Real MCTS
6. CLR- Real MCTS
7. creating objects like tables, SPs, functions, triggers - both books
8. performance tuning chapter of 'Real MCTS'

Hope this helps you...

Wednesday, November 9, 2011

Prometric Test Centers in Pune

Here is the list of prometric test centers in pune where you can give various Microsoft certification exams:

Seed Infotech Ltd
Site Code: IIF64
42 16 Panchsheel
Income Tax Office Lane
Off Karve Road
Pune, Maharashtra 411004
Phone: 2546679

VINSYS IT SERVICES (I) PVT LTD
Site Code: IIH4
L 401 TO 409 Megacenter
3rd Floor
Hadapsar
Pune, Maharashtra 411028
Phone: 30483032

KARROX TECHNOLOGIES LTD
Site Code: ii447
301-305,3rd floor
Kamla Arcade Balgandharv
ChowkJM Road1204,
Shivaji Nagar
Pune, Maharashtra 411007
Phone: 41007600
   
NIIT LTD
Site Code: IID
Aurora Towers,East Wing
4th Floor,Camp,M.G.Road
Pune, Maharashtra 411001
Phone: 30567017/19
   
Certification Guru
Site Code: II716
Off. no 9, Mahalaxmi Heights
Near Bank of Maharashtra
Morwadi corner, Finolex Chowk
Pune, Maharashtra 411018
Phone: 64191414
   
KNOWLEDGE MINE
Site Code: IIB85
UNIT NO - 9
TUKARAM COMPLEX
HINJEWADI, WAKAD ROAD
PUNE, Maharashtra 411057
Phone: 9822041028