Yearly Archives: 2006

Sify Screw up

Just got up to disconnect the Internet as premium download rate starts from 8:00 AM. But hey… Eternal Sunshine of the Spotless Mind just needs 2 minutes to complete the download. So I decide to disconnect after the movie is completed. After the download I checked the usage. Oh my god. 107 MB between 8:10 to 8:50. That’s impossible. A phenomenal speed of 3.75 MB a minute. Now I know why I lost 6 days of Internet usage. (Sify decreases your usage be one day for every 25 MB downloaded above 150 MB daily download limit.) Good way of making money Sify. Fudge the downloads and charge the customers. If you use Sify then do keep a tab on what they show as usage on “My Account”. Just logged complaint with them. #4212247. There is no doubt that Sify Broadband gives what it promise. I get speed of 25K for 256kbps plans which is acceptable. I used Beam CableSystem when I was staying at Company’s Guest House and I used to get same speed for 512 kbps plan. Let us see what action they take for over billing.

MicroStrategy Free Form SQLs simplified

I got up so late today. It was 10:05. I’m supposed to be in office by 10:00. I straight jumped into shower, got dressed, had Idlies in breakfast and reached office by 11:15. There is reason for being extra late. 😉 Working on the report of Game-bookers KPI, I gave some final touches to the SQL. I really enjoyed making final touches, because I made changes to Free Form SQL reports myself alone. I had to depend upon some one knowing the SQL well to do the same. I removed one complete join that was a great achievement. The joy was only short lived. I had to redo that join due to one separate WHERE clause. I spoke to Adi about my planned leaves in November and I didn’t get any positive reply. Ritesh also told me about the rules that I must follow while creating free form SQL report in MicroStrategy, as no other guy would be bale to make or create any schema change till I’m done. I hope I would be able to keep it, because after today’s tweaking the SQL my confidence level is increased very much. I printed the Rent receipt to be sent to Saama Technologies, my ex-employer, and got sign of landlord, Mr. Neeraj Jamwal, too. 😉 I took the help of a site for the same. Here is the link. http://www.vakilno1.com/forms/delhirentcontrol/form_b.htm